Is there code for finding last row of data?
 

verc Wrote:
Hi all,

I need to produce graphs of data in spreadsheets for the rang
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

--
ver
-----------------------------------------------------------------------
verc's Profile: http://www.excelforum.com/member.php...fo&userid=1596
View this thread: http://www.excelforum.com/showthread.php?threadid=27439

Is there code for finding last row of data?
 

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