Sheet Reference Syntax

[Guest]

I'm pretty sure I've done this before, but can't recall the syntax...

I have a variable strDataSheetName that is a string and refers to the name
of a worksheet. I have it as a string variable, because the name of the
sheet I want to refer to has to do with the name of the sheet I am on.

How do I select this sheet using the variable name? See code below (this
syntax does not work)...

ActiveChart.SetSourceData Source:=Sheets("" &
strDataSheetName).Columns("A:F"), PlotBy:=xlColumns

Thanks!

 

[Guest]

worksheets(strDatasheetname).Select

 

[Guest]

It doesn't like that. I think I misstyped: not selecting, but getting data
from the sheet.

This works:

ActiveChart.SetSourceData Source:=Sheets("Sheet1").Columns("A:F"),
PlotBy:=xlColumns

But I want to refer to my variable instead of hardcoding the name.

 

[Guest]

if that works, then
s = "sheet1"
ActiveChart.SetSourceData Source:=Sheets(s).Columns("A:F"),
PlotBy:=xlColumns

should work in the same place as an example.

 

[Guest]

Oh, duh. I had a different problem. Nevermind.

if that works, then
s = "sheet1"
ActiveChart.SetSourceData Source:=Sheets(s).Columns("A:F"),
PlotBy:=xlColumns

should work in the same place as an example.