Thread: Insert worksheet at end
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JamesArchibald[_4_] JamesArchibald[_4_] is offline
external usenet poster
  
Posts: 1
Default Insert worksheet at end

Hi,

I am trying to insert a blank worksheet using the code:

Sheets.add

The problem is that the new worksheet inserts itself to the left of the
active sheet. I would like it to appear at the end of the sheets e.g.
Sheet 1, Sheet 2, Sheet 3, new sheet.

Any help would be appreciated.

Thanks


--
JamesArchibald
------------------------------------------------------------------------
JamesArchibald's Profile: http://www.excelforum.com/member.php...o&userid=33284
View this thread: http://www.excelforum.com/showthread...hreadid=565087

Reply With QuoteReply With Quote