| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a specific row in named range
Hi All
I need to select the second row in a named range ("Overviewfinal") and insert copied rows so that the named range expands to take the new data. I tried the following, but got an error?? Could someone tell me what I've done wrong & how I should do this? .... Sheets("Overview Template").Select Range("Overviewfinal").Range(Cells(1, 1)).EntireRow.Select Selection.Insert Shift:=xlDown ..... Thank for your help BeSmart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Named Range in Worksheet | Excel Programming | |||
| how to select ALL named shapes in range | Excel Programming | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| create named range specific to worksheet | Excel Programming | |||
| named range not specific to worksheet | Excel Programming | |||
Threaded Mode
