I'm using this code in my macro:
Selection.AutoFill Destination:=Range(Selection, Selection.End(xlDown))
to copy the excel formula I have in cell H2 and paste it to the cells below. However, it copies the formula all the way down and right past my block of data. I only want it to "autofill" the cells for which there is data in the columns to the left.
I'm sure there is a simple solution I just dont know what it is!
Tks
Bookmarks