Won't Delete

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
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
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top