| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert copied cells above hidden Named Range
I'm not sure what happened here - this worked in the past, but suddenly there
is a problem with "Selection.Insert Shift:=xlDown". The "record end" named range is still there, so it's not that. The marco is supposed to go to "RecordEnd" which is hidden, unhide it, insert the copied cells while pushing "RecordEnd" below the inserted cells. It worked before - anybody know what I'm doing wrong? Sheets("DRIVER LIST").Select Application.Goto Reference:="RecordEnd" Selection.EntireRow.Hidden = True Selection.Insert Shift:=xlDown Application.Goto Reference:="RecordEnd" Selection.EntireRow.Hidden = True ActiveCell.Offset(-1).Activate |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Hidden Named Range | Excel Discussion (Misc queries) | |||
| Refer named range in a copied sheet | Excel Programming | |||
| Named range is hidden when using OFFSET() | Excel Discussion (Misc queries) | |||
| Named-range source-data for pie charts on copied worksheets | Charts and Charting in Excel | |||
| Insert copied cells | Excel Worksheet Functions | |||
Threaded Mode
