VBScript macro to count fields in Excel worksheet?
Posted on 2006-06-01
I know this can be accoplished using Excel's built in functions, but I need it to run from a macro.
I have a spreadsheet and want to count the number of names in column A.
Column A has misc headings from row 1 to row 8.
Data always starts on row 9 and continues for a different number of rows depending on report content.
There is a blank line after the last row of data followed by the phrase "Created on 6/1/06" --( the date changes depending on when the report is run.)
The results should be displayed in cell X1.
How can I count the number of names in the column?