Hello All,
I have:
This is working
However, I would like it to AutoFill only to last entry in column AB. When I replace Range("A"& Rows.Count...) above with "AB" it still goes all the way to the bottom.
How do I make the AutoFill Stop with the last entry of AB?
Thanks for the help
I have:
VBA Code:
Sheets("HV-1 PVT").Select
Range("AA4").Select
Application.CutCopyMode = False
ActiveCell.Formula = "=AE4+AG4+AI4"
Selection.AutoFill Destination:=Range("AA4:AA" & Range("A" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select
Selection.NumberFormat = "0"
This is working
However, I would like it to AutoFill only to last entry in column AB. When I replace Range("A"& Rows.Count...) above with "AB" it still goes all the way to the bottom.
How do I make the AutoFill Stop with the last entry of AB?
Thanks for the help