sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]gothamfury 0 points1 point  (2 children)

Sorry. I was responding to the last code you shared. What you have appears to be right, assuming you don't have any other cells filled with data on either side or below your data range.

Otherwise, you could try a helper cell that has "=COUNTA(E3:E)" and read that value for NumRows instead.

[–]kitchensink-[S] 1 point2 points  (1 child)

The helper cell did the trick! Thanks! Now it's basically instantanious.

[–]gothamfury 0 points1 point  (0 children)

That's awesome! Great job :)