Won't Delete

[Parra]

I have a formula in column J, because I want to delete blank rows I copy, paste special, values, column J, then run a delete empty row macro.

The macro works fine.

The problem is something remains in the blank cells of column J. This is the problem I know it.

Any ideas or suggestions on how I can go around it or fix it???

Thanks

[Mark W.]

On 2002-04-19 16:05, Parra wrote:
I have a formula in column J, because I want to delete blank rows I copy, paste special, values, column J, then run a delete empty row macro.

The macro works fine.

The problem is something remains in the blank cells of column J. This is the problem I know it.

Any ideas or suggestions on how I can go around it or fix it???

Thanks

If your formula is something like...

=IF(logical_test,value_if_true,"")

...that "remaining something" is a text string ("") with a length of zero. Just because you can't see it doesn't mean nothing is there! If a cell contains "" that cell is nonblank (not empty).

[ This Message was edited by: Mark W. on 2002-04-19 16:10 ]

[Parra]

Thanks for the explanation. The formula you put up is close to the formula I copied pasted.

Any suggestions? On how to fix my problem.

Thanks

[Mark W.]

On 2002-04-19 16:21, Parra wrote:
Thanks for the explanation. The formula you put up is close to the formula I copied pasted.

Any suggestions? On how to fix my problem.

Thanks

You could select these cells, choose the Edit | Text to Columns... menu command, and press [ Finish ]. This will convert any cells containing "" into blank cells.