I have built a macro that highlights from cell A4 to Cell AU4 then down to cell A1001 to cell AU1001 and it sorts the data ascending based on number data in column A. The data will always start in cell A4, but there will not always be data on each row to cell A1001. My problem I always need this entire area to highlight and sort which I have. But, if there is no data for example from cells A465 to A1001, when I sort ascending the blank lines sort and appear first. I need a macro to add to the existing macro, when I sort only the rows with numbers will appear first. But, I do not need to delete the blank rows. As these rows contain calculations and additional information may be added and then sorted again.
thanks in advance.
thanks in advance.