I am trying to run some code that will delete all the empty cells in column A. The code I am currently using is:
I know for a fact that several thousand lines in column A are not blank, however, after this code runs, my entire worksheet is deleted. If I try to manually delete the blank rows using the same method (i.e. I highlight column A, and the GoTo | Special | Blanks etc..) I get an error saying the selection is too large. The data range is only 48000 lines, so the blank lines must be less than that. Why would I be getting the error? Any thoughts? Thanks in advance.