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