View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Carole Drake
 
Posts: n/a
Default How do I insert a new worksheet consecutively?

I'm kind of new to macros - how would you go about using one for this?

"Dave Peterson" wrote:

Even inserting from the Insert|worksheet will insert before the activesheet.

I think if the OP wants more control, a macro would be in order.


"lady-pearl" wrote:

On my current Workbook I would like to insert anywhere from 1 - 10 extra
worksheets, but I notice that when I do the "insert worksheet" they are not
always consecutive. I am finding that I have to drag them back to the place
where I want them to appear originally.

Thanks!

Pearl

--

Dave Peterson


--

Dave Peterson