View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tina tina is offline
external usenet poster
 
Posts: 139
Default 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