Wednesday 3 September 2014

How to check available Rows in Microsoft Excel Using VBA?

Hi,

Some time people is still using Microsoft Excel 2003 and certain may up to 2010. Major different between these version is number of rows available. So to set stop point when we loop using VBA code we need to know number of rows available. Below code will trigger this point.

Cells.Rows.Count

Please try it and comment. Thanks

1 comment:

RH said...

Hi, I enjoy reading your site! Is it okay if I contact you through email? Please email me back.

Thanks!

Harry
harry.roger10 gmail.com