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
|