Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
the code you posted doesn't unhide the hidden range. it hides in again. which is what i think is wrong. change the first Selection.EntireRow.Hidden = True to false ie Selection.EntireRow.Hidden = False then it should start doing what you expect. i think. regards FSt1 "Munchkin" wrote: 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 | |
|
|
![]() |
||||
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 |