Hi Tina,

Sometimes when importing data the imported cells look blank, but really
contain spaces that you cannot see. For example, in a cell, press space bar a
couple times and press enter. The cell looks empty, but it is not. It
contains some spaces.

You may have to resort to a macro to "clean" up your sheet if this is the
case. Look at the "Trim" function in help.

HTH


"tina" wrote:

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