Quote:
Originally Posted by Kannand
I just came across this code in another post, that seems to work....
|
Still not sure exactly what you are doing as you talked about formulas and now you're talking macros. Not sure how what you posted seems to work when it doesn't even compile.
Code:
Sub update_all()
Dim LR As Long
With ActiveSheet
LR = .Range("I" & Rows.Count).End(xlUp).Row
.Range("J4:J" & LR).Value = .Range("I4:I" & LR).Value
End With
End Sub
The code above will first look at column I to see what the last rows is then copied column I to column J.