is it possible to insert a worksheet to the right of the currently selected sheet? tj
T tjtjjtjt Jun 18, 2004 #1 is it possible to insert a worksheet to the right of the currently selected sheet? tj
B {*BoB*} OZZIE Jun 18, 2004 #2 Would it really be an "insert" then? I'm sure the MVP's can come up with some code..
J Jim Cone Jun 18, 2004 #3 ?, Sub PutItThere() Worksheets.Add after:=ActiveSheet, Count:=1 End Sub Jim Cone San Francisco, CA
S sanjay_suda Jun 18, 2004 #4 you could always insert as normal (to the left) and move the workshee to the left or right Have Fu
J JE McGimpsey Jun 18, 2004 #5 Take a look here: http://www.mcgimpsey.com/excel/insertsheettoright.html
T tjtjjtjt Jun 20, 2004 #6 Thank you JE and Jim. tj JE McGimpsey said: Take a look here: http://www.mcgimpsey.com/excel/insertsheettoright.html Click to expand...
Thank you JE and Jim. tj JE McGimpsey said: Take a look here: http://www.mcgimpsey.com/excel/insertsheettoright.html Click to expand...