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
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