Insert to the right

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is it possible to insert a worksheet to the right of the currently selected sheet?

tj
 
Would it really be an "insert" then? I'm sure the MVP's
can come up with some code..
 
?,

Sub PutItThere()
Worksheets.Add after:=ActiveSheet, Count:=1
End Sub

Jim Cone
San Francisco, CA
 
you could always insert as normal (to the left) and move the workshee
to the left or right

Have Fu
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel-Adding rows to master sheet that will be inserted on following worksheets 1
VBA - retrieve data on last create named range from previous inserted named range 0
Inserting Rows into multiple worksheets 2
add personal template to the insert worksheet dialog box 2
password protect allowances 1
'Cannot insert object' message when I try to put a button on a worksheet 7
Inserting Picture Into Protected Worksheet 1
Insert A Worksheet using VBA 3

Back
Top