setSourcedata

T

tony wong

activecell is J113

how can i replace J113 with ab?

i don't know how to arrange the double quote. Thanks a lot.

ab = ActiveCell.Address
Charts(1).SetSourceData Source:=ABCsheet.Range("A1:J113")
 
T

Tom Ogilvy

ab = ActiveCell.Address
Charts(1).SetSourceData Source:=ABCsheet.Range("A1:" & ab)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I think the problem is in .SetSourceData ?? 2
Chart Question 2
nested "If" fuction 4
Plot Ranges 2
Set Source two Worksheets 4
Export from EXcel to jpg with 2007 4
SetSourceData Source = pivot table on same sheet 2
Programming Excel tru Access 4

Top