| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Graphing Current Sheet?
I would like to have my macro graph the sheet I am on without having t type in different names as I change different files. The SourceDat looks like this right now: ActiveChart.SetSourceData Source:=Sheets("sName").Range("A1:B400") PlotBy _ :=xlColumns Is there any way I can get sName to be the name of the curren worksheet I am viewing -- Loss ----------------------------------------------------------------------- Losse's Profile: http://www.excelforum.com/member.php...fo&userid=2481 View this thread: http://www.excelforum.com/showthread.php?threadid=38368 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display current sheet name being processed in macro | New Users to Excel | |||
| How can I Run a query from VB macro with out affect current data in the same sheet? | Excel Discussion (Misc queries) | |||
| Graphing past months (totals) and current month (weekly total) in | Charts and Charting in Excel | |||
| Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
| Use current sheet name in Macro | Excel Programming | |||
Hybrid Mode
