| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Reference Syntax
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Reference Syntax
worksheets(strDatasheetname).Select
-- Regards, Tom Ogilvy "Jennifer" wrote: 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Reference Syntax
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. "Tom Ogilvy" wrote: worksheets(strDatasheetname).Select -- Regards, Tom Ogilvy "Jennifer" wrote: 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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Reference Syntax
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. -- Regards, Tom Ogilvy "Jennifer" wrote: 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. "Tom Ogilvy" wrote: worksheets(strDatasheetname).Select -- Regards, Tom Ogilvy "Jennifer" wrote: 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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet Reference Syntax
Oh, duh. I had a different problem. Nevermind.
"Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "Jennifer" wrote: 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. "Tom Ogilvy" wrote: worksheets(strDatasheetname).Select -- Regards, Tom Ogilvy "Jennifer" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell reference syntax | Excel Worksheet Functions | |||
| Worksheet reference syntax? | Excel Discussion (Misc queries) | |||
| Reference for VB syntax for Excel functions | Excel Programming | |||
| Syntax to return the value of a control by reference | Excel Discussion (Misc queries) | |||
| Syntax for Range Reference | Excel Programming | |||
Linear Mode
