I want to do in VBA the equivalent of double-clicking on the fill handle.
When I record the macro, I get a hard coded range, as in:
Selection.AutoFill Destination:=Range("B2:B15")
I want the range to be a variable length, ie, however many contiguous rows are
in column A. I tried:
Range("B2", Range("A2").end(xldown).offset(0,1))
but I got a two column range out of this rather than one. What range will solve
my problem?
--
Thanks,
Fred
Bookmarks