I am trying to find a way to autofill down, when there is data in the column
to the left. I tried a bunch of things, including the macro recorder, and
cant get a solution. The macro recorder gave me a result such as:
Selection.AutoFill Destination:=Range("C2:C9")

But my range will change all the time and thus I cant use this hard-code
reference.

Please offer a suggestion or two€¦



Regards,
Ryan---


--
RyGuy