Blank Cells being treated as Values by Excel

Hello,


After I use the formula =IFERROR(VLOOKUP(A2439,PEIHIERARC_Hierarchy_to_Cost_Ce!K:O,5,FALSE),""), the cells with that appear blank because of the "" , are still not treated as blank cells by excel.

is their a macro that can identify in a certain cell range which cells are "" and actually clear them to be truly blank?

thanks,

Lorenzo

essentially,

I want to go to select the range of cells with only values in them. using this range(range("g13"), range("g13").End(xlDown)).Select but as I mentioned previously, it still grabs the cells below the actual values even though they are blank because of the "". For example I want to select just till W22403 but there are cells below that that the above statement grabs because they are blank but not treated as blank.
wNig Creek C-83-A/94-H-4(Licenced Only) (W16693)
Misc Drill, Comp, ABandonment Costs (W90099)
Peoc Calling Lake 100/15-18-073-21 W4 (W05229)
Peoc Calling Lake 100/11-13-073-21 W4 (W05231)
Peoc Francis 100/05-34-073-21 W4 (W06393)
Peoc Francis 100/16-21-073-21 W4 (W06394)
Peoc Francis 100/12-27-073-21 W4 (W06570)
Peoc Callw 100/12-10-072-20 W4/03 (W19055)
Francis 100/11-15-073-21 W4/02 (Not Prod (W19061)
Peoc Gambler 100/14-26-072-21 W4/03 (W19063)
Peoc Francis 100/15-18-073-21 W4/02 (W19094)
Peoc Francis 100/11-15-073-21 W4/03 (W19159)
Peoc Francis 100/11-15-073-21w4/04 (W22402)
Peoc Francis 100/16-21-073-21w4/02 (W22403)
"" (appears empty on excel)
""(appears empty on excel)
""(appears empty on excel)

hmm maybe I didnt articulate this well. essentially I need a macro that deletes cells that appear blank because they contain "" in them. Right now excel doesnt treat them as actually blank. I cant just manually delete them because this is something that has to happen over and over again.

thanks,

Jon

I tried this but it didnt seem to work:
ange(range("g13"), range("g13").End(xlDown)).Select
If (cell.Value = "") Then cell.ClearContents

Attachment 393530You will notice if you go to cell A1 and hit CTRL:Shift:down arrow it will bring you to cell 2231. I just want it to bring me to A66. Excel still doesnt treat any cell below 66 as a true blank. it feels something is in there.

thanks,

Jon

Will this I get "cant find cells"