| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells not registering as blank
Hi
I was using following code as part of macro which worked fine but now it errors as no blank cells I tried highlighting row 2 and selecting edit goto special blank cells states no cells . there are empty cells Rows("2:2").Select Selection.SpecialCells(xlBlanks).Select I have not made changes to spreadsheet layout just imported new data any Ideas Thank you Tina |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Registering UDFs | Excel Programming | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Code for Registering Add-in | Excel Programming | |||
| Registering an OCX with VBA | Excel Programming | |||
Threaded Mode
