Here is the code:
LRow = ActiveSheet.UsedRange.Rows.Count

Wolfram

"verc" wrote:


verc Wrote:
Hi all,

I need to produce graphs of data in spreadsheets for the range
A2:A(last row) for spreadsheets with different numbers of rows of data.
Is there a macro function to find the last row of a column of data?

Thanks,
Ambert

bump. Any nudge in the right direction would be appreciated.


--
verc
------------------------------------------------------------------------
verc's Profile: http://www.excelforum.com/member.php...o&userid=15963
View this thread: http://www.excelforum.com/showthread...hreadid=274396