| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a single word match in a text string and assigning a code | Excel Worksheet Functions | |||
| Finding Office and Last Code Used on Acct Based on Multiple Critie | Excel Discussion (Misc queries) | |||
| Can any one suggest code/formula for finding the CAGR | Excel Worksheet Functions | |||
| Function/VB Code for finding pattern blocks in number sets? | Excel Programming | |||
| Please, any help with a problem finding vba code | Excel Programming | |||
Hybrid Mode
