I use the code below to autofill columns,(using formulas), which is done
successfully except that it creates garbage past the last line of the
file.
Range("V2:AF2").AutoFill Destination:=Range("V2",
Range("AF2").End(xlDown)(0))
How can I stop it doing this to row 65536?
Thanks
--
leskoby
------------------------------------------------------------------------
leskoby's Profile:
http://www.excelforum.com/member.php...o&userid=26616
View this thread:
http://www.excelforum.com/showthread...hreadid=399956