Can I do this without VBA?
Widman,
The five statements are merely assigning values to five variables T1, T2,
cSt1, cSt2 and T3.
from the current cell and the four cells underneath it.
Without knowing how the numbers are transformed it is a little difficult to
advise on the formula required.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.
"widman" wrote:
I have this in a VBA formula that I want to get into a regular excel sheet
without the VBA. I can easily work with the five values once I can figure
out the +273 as double. What does that mean and how can I put this into an
excel sheet
Set cell = ActiveCell
T1 = cell.Offset(0, 0).Value + 273#
T2 = cell.Offset(1, 0).Value + 273#
cSt1 = cell.Offset(3, 0).Value
cSt2 = cell.Offset(4, 0).Value
T3 = cell.Offset(5, 0).Value + 273#
|