Thread: Copy to end
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
comotoman[_6_] comotoman[_6_] is offline
external usenet poster
 
Posts: 1
Default Copy to end


my line is:
Sheets("Sheet 1").Copy After:=Sheets(3)

This is part of a sheet copy macro, I need it to copy "sheet 1" to the
end, not after sheets(3). The workbook can have 40+sheets. Any help
would be great!!!


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=474121