| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if not empty cells skip
I have this section of code which has been working fine, up until now, when i
try to run it it highlights the third line, I think this is because sometimes there are no empty cells where i am trying to run it, can i get it to ignore the code only if there are no empty cells? lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row Range("B" & lngLastRow + 1 & ":DY" & lngLastRow + 1).Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.FormulaR1C1 = ".." |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| skip cells with zero values in chart (cells not empty) | Charts and Charting in Excel | |||
| how do you skip empty cells or zeros when calculating the average | Excel Programming | |||
| paste special / skip empty cells doesn't work!? | Excel Worksheet Functions | |||
| How to skip empty cells while running a macro? | Excel Programming | |||
| Skip empty and text cells | Excel Programming | |||
Threaded Mode
