Hi, youngtusk87,
have you tried using the Autofilter, show only the filled cells and the not use something like
but instead
You could use SpecialCells to delete the blanks in a column (use EntireRow if the whole row is to be deleted), you could use only the constants in that row and build a range on these rows and the UsedRange.
Please mind that the use of SpecialCells will throw up an exception if no such cells are found so either make sure there are cells available or use an error handler like On Error Resume Next but be aware to set it back after the line with SpecialCells and check the err and decide to either go on with the code or end the macro.
Ciao,
Holger
Bookmarks