i want to apply the formula down till the last used rows of column H.
tat.PNG
The formula is F3 - E3 and this formula is to be applied to the column H. Also how do i round down the number in column H.
Below is the code:
ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-3]"
Range("H3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Activate
ActiveSheet.Paste
Its applying the formula only to H3 not to the below rows, as u can see in the above pic.
Bookmarks