Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a variable cell location I am finding using the following:
'Find 'Released' Header Row Dim CrntF As Range Set CrntF = Range("F49") Do Until ActiveCell = "RELEASED" On Error Resume Next CrntF.Select Set CrntF = ActiveCell.Offset(1, 0) Loop 'Move down to 1st project, and over to Title CrntF.Offset(1, 8).Select This selects the correct starting cell, but I need to copy this cell & the next 19 cells below it. I hope this is simple. Thanks in advance for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data: select a cell x rows below the current, where x is designate | Excel Discussion (Misc queries) | |||
Select all cells in a column up to a blank cell | Excel Programming | |||
Macro €“ select all cells in current range | Excel Discussion (Misc queries) | |||
Want macro to select current cell | Excel Programming | |||
Select current region less one column | Excel Programming |