View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
leskoby[_3_] leskoby[_3_] is offline
external usenet poster
 
Posts: 1
Default Stopping Autofill at alst line of file


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