Hi All,
I'm trying to develop some working VBA code to carry out a simple operation of a range of cells, applying the operation to the cell values within the range. I've gathered the macro from another post, and modified it, but really Im a noob and am not sure what Im doing.
LR = Range("A" & Rows.Count).End(xlUp).Row
With Range("F4:O" & LR)
.Value = .Value * (1+Start!$C$15)^(F$3-Start!$C$13)
End With
F3 would have to move across the columns as operation proceeds. For example, all cells in F would use F3, cells in G would use G3, H would use H3, etc to column O.
Any of you VBA guru's out there feel like making a humble noob's Friday morning????
Peace
Bookmarks