Define a cell empty instead of ""

[Pedro Morais]

Hi all,

I appreaciate your help on this.

I'm using VBA to insert formulas in some cells as below:
"=IF(ISNA(VLOOKUP(RC[-1],IE!R2C2:R1500C38,2,FALSE)),"""",VLOOKUP(RC[-1],IE!R2C2:R1500C38,2,FALSE))"

Then I select that area and paste special values over it.

Problem is then when I SORT, because my formula defines when is NA() the cell to be = "", it will put those spaces before.

Is there anyway I can define a cell empty instead of ""?

Thansk

 

[Boller]

Instead of using a worksheet formula and then converting to values, perhaps use Find to loop through each cell and if not found then clear contents of the cell.

 

[Dryver14]

try this

http://www.ehow.com/how_6025815_remove-non_blank-cells-filter-excel.html