Macro to count rows

[Excel Outsider]

Hi,
I have a macro to count the rows in a report, the macro does many other things as well.

Please Login or Register  to view this content.

This works perfectly if i have more than two rows, but if i only have 2 rows i get:
Run-time error '1004'
AutoFill method of Range class failed, I'm guessing its because the range is A14:A14.
I'm using this macro within templates which are attached to reports within our application, so I'd prefer to avoid declaring variables as xlsm templates cannot be used by all our users.
Anyone have any simple tweaks I can do to make this work when the range is one row?
Any help would be appreciated.
Thanks!

[theradpotato]

This is really crude, but works (on my computer at least).

Please Login or Register  to view this content.

[JBeaucaire]

How about this:

Please Login or Register  to view this content.

[Excel Outsider]

I had some other code so I couldn't use the end Sub with the first count, I updated to

Please Login or Register  to view this content.

Once again thanks everyone for all your help!