ExcelBanter - setSourcedata

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - setSourcedata (https://www.excelbanter.com/excel-programming/383731-setsourcedata.html)

tony wong

setSourcedata

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")

Tom Ogilvy

setSourcedata

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

--
Regards,
Tom Ogilvy

"tony wong" wrote:

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")

tony wong

setSourcedata

Thanks a lot.

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

--
Regards,
Tom Ogilvy

"tony wong" wrote:

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")

All times are GMT +1. The time now is 10:45 PM.