Excel vba count non empty cells in range

Top sites by search query "excel vba count non empty cells in range"

Remove blank rows in Excel with this VBA code - New Horizons Learning Centres Australia

  http://www.nhaustralia.com.au/blog/remove-blank-rows-excel-vba-code/
Therefore, if you want to leave the blank rows for the first 2 or 3 tables but remove those from say, table 4 downwards then select a cell in table 4 before running the program. Although you can select consecutive rows and delete them in Excel itself, you may not really want to do this when they are non-consecutive and spread out

Selecting non-blank cells in Excel with VBA - Stack Overflow

  http://stackoverflow.com/questions/821364/selecting-non-blank-cells-in-excel-with-vba
It will copy all of the data in the original workbook to a new workbook, but it will have added 1 to each value, and all blank cells will have been ignored