| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| Finding specific sheets within a workbook | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Threaded Mode
