Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip code
How can I skip this code if Cell A1 of the row below the active cell
contains a value? Range(.EntireRow.Columns("A").Cells(1), _ .Offset(2, 0).EntireRow.Columns("A")).FillDown |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip code
If Activecell.Offset(1,0).Value < "" The
Range(.EntireRow.Columns("A").Cells(1), _ .Offset(2, 0).EntireRow.Columns("A")).FillDown End If -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Patrick Simonds" wrote in message ... How can I skip this code if Cell A1 of the row below the active cell contains a value? Range(.EntireRow.Columns("A").Cells(1), _ .Offset(2, 0).EntireRow.Columns("A")).FillDown |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros skip steps and/or stops in the middle of code | Excel Programming | |||
How to have a Macro skip code if PivotTable/PivotField is not there | Excel Programming | |||
skip some code | Excel Programming | |||
skip code | Excel Programming | |||
Excel skip some lines of VBA code | Excel Programming |