lhtqasonline
01-19-2009, 07:11 AM
Hi
I need assistance with code copied from another thread.
I want to be able to count the amount of rows in a sheet.
While the below code works i need it to exclude the header row.
MsgBox Intersect(Range("A:A"),Cells.SpecialCells(xlCellTypeConstants).EntireRow).Count
Also need the value in a cell on the spreadsheet and not on a msgbox
Any assistance appreciated
I need assistance with code copied from another thread.
I want to be able to count the amount of rows in a sheet.
While the below code works i need it to exclude the header row.
MsgBox Intersect(Range("A:A"),Cells.SpecialCells(xlCellTypeConstants).EntireRow).Count
Also need the value in a cell on the spreadsheet and not on a msgbox
Any assistance appreciated