Thread: Variables and graphs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Variables and graphs
Try

ActiveChart.SeriesCollection(1).Values = "=three!R" & setin &
"C11:" & Rsetout & "C11"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"teepee" wrote in message
...
Quick question....

If I have a VBA saying

ActiveChart.SeriesCollection(1).Values =
"=three!R3000C11:R4000tC11"

can I replace it with

ActiveChart.SeriesCollection(1).Values =
"=three!RsetinC11:RsetoutC11"

where setin and setout are declared variables? I'm a bit hazy
on the syntax of this one.

Cheers

tp



Reply With QuoteReply With Quote