Link to home
Start Free TrialLog in
Avatar of MelissaCG
MelissaCG

asked on

Copy Chart with the range

Hi, I need to copy a range to another sheet... The problem is that there is a chart in this range, and i need to copy it in the same relative position, but Range.Copy doesnt get it... Whats the best way to do it??

Thanks
ASKER CERTIFIED SOLUTION
Avatar of JolyonSpence
JolyonSpence

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MelissaCG
MelissaCG

ASKER

I need to paste via vba too... But if I use xlpasteall it will paste formulas, and i need values and number formats...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial