If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Activate all sheets
Hi
I need help with the following macro: I am grouping all the worksheets together, and selecting the row, above which I wish to insert a new row. I want to insert a new row on all sheets, the enclosed macro at the moment is only inserting a new row on the first sheet. Selection.EntireRow.Insert Range("AD5:AE5").Select Selection.AutoFill Destination:=Range("AD5:AE594"), Type:=xlFillDefault Range("AD5:AE594").Select ActiveWindow.ScrollRow = 5 Range("D5").Select Can anyone help me with this? George Gee |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | EDSTAFF | Worksheet Functions | 0 | November 14th, 2005 03:27 PM |
In 3 active sheets in wkbk, determine& display the # of sheets that have data | wrpalmer | General Discussion | 1 | November 4th, 2005 02:01 PM |
How do you activate Office 2003 by phone? | Vanguard10 | General Discussions | 2 | May 9th, 2005 07:51 PM |
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | RICHARD | Worksheet Functions | 1 | March 15th, 2005 05:49 PM |
(¯`·._.·[ Extract Data From Multiple Sheets ]·._.·´¯) | hyperdreamz | General Discussion | 1 | September 29th, 2004 04:03 PM |