Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems with SetSourceData.

Status
Not open for further replies.
e97fw

e97fw

Electrical
Joined
Jun 20, 2002
Messages
1
Location
SE
Hi!

Trying to plot data from selective curves from the power-grid. Since the number of data constantly changes I'm having problems with:

ActiveChart.SetSourceData Source:=
Sheets("Blad2").Range("A1:B???"), PlotBy:= _ xlColumns

I would've loved do write it like this:

ActiveChart.SetSourceData Source:=
Sheets("Blad2").Range(Cells(1,1),Cells(2,x)), PlotBy:= _ xlColumns

But that doesn't work, someone knows how to get around it?

Thanks in advanced from Sweden.
 
Status
Not open for further replies.

Similar threads

EngProgrammer
  • Locked
  • Question Question
Help with multiple DLLs
Replies
2
Views
1K
xwb
xwb
rssql
  • Locked
  • Question Question
Realtime data collection, without being interrupted
Replies
4
Views
512
IRstuff
IRstuff
Befuddled
  • Locked
  • Question Question
Launch batch File with argumnets from VB
Replies
1
Views
181
cowski
cowski
lefowler
  • Locked
  • Question Question
How are icons applied to .exe files produced with VB?
Replies
1
Views
152
CJKruger
CJKruger
hateraid
  • Locked
  • Question Question
Generating Random Passwords with ASP.NET and VB
Replies
0
Views
163
hateraid
hateraid

Part and Inventory Search

Sponsor

Back
Top