I've created the necessary excel objects and am referencing a spreadsheet from a form module. I now need to determine how many rows of data are in the sheet. Assuming there are no blank rows, how can I determine how many rows of data are in column 'A' for example.
I've tried a couple methods I found in the forums like the ActiveCell property and Range("A1:A" & lRow).Find(360, , , xlWhole, xlByRows, xlNext).Row), but both give errors.
I don't know, maybe its just the syntax?
I've tried a couple methods I found in the forums like the ActiveCell property and Range("A1:A" & lRow).Find(360, , , xlWhole, xlByRows, xlNext).Row), but both give errors.
I don't know, maybe its just the syntax?