Let's say that I want to count the number of rows on a particular worksheet (Sheet1)
How would I do this in VBA? Here is the exact formula that works for me in Excel (note you have to turn this into an array to work):
Thank you in advance!
How would I do this in VBA? Here is the exact formula that works for me in Excel (note you have to turn this into an array to work):
Code:
=MAX(ROW(Sheet1)*(Sheet1<>""))
Thank you in advance!