How do I highlight all the context area?

[Guest]

Hello,

I do have a macro that let user select an excel file and create a chart.
However, I am unable to run the chart without knowing the number of rows in
the worksheet.

Here is what I have:

ActiveChart.SetSourceData Source:=Sheets("Sheet1"). _
Range("A1:C374"), PlotBy:=xlColumns
ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Chart1"

The Range("A1:C374") is changing based on the file. How do I get those
dynamically?

Thanks.
le9569

 

[Guest]

Try
Activesheet.usedrange
HTH,
Gary Brown

 

[Guest]

Thank you.

Try
Activesheet.usedrange
HTH,
Gary Brown