On Nov 27, 9:12 am, jlclyde wrote:
I have a range that keeps changing and I need to count how many are in
this range. I copy and past information from one workbook to
another. I delete rows that are not needed and then I need a count of
how many rows are left. Any help would be greatly appreciated.

Thanks,
Jay

Nevermind I have made a workaround. I am just telling my variable to
always equal 20. It will overwrite itself the next time the macro is
ran.
Jay