Need help with dynamic range Sheet.name & range & lastrow

[Akbarov]

Hello community,

I am trying to use dynamic range for chart Xvalues

ActiveChart.FullSeriesCollection(1).XValues = "='MAIN DATA'!$E$3:$E$" & lr

Instead I want to use

ActiveChart.FullSeriesCollection(1).XValues = "=" sh.name & "!" & "$E$3:$E$" & lr

I guess I do something wrong, I get error.
Any help will be appreciated.

Thank you.

[Marc L]

You just forgot the quotes of the original formula !

ActiveChart.FullSeriesCollection(1).XValues = "='" & sh.name & "'!$E$3:$E$" & lr

► Do you like it ? ► ► So thanks to click on bottom left star icon ? ★ Add Reputation ? ! ◄ ◄

[Akbarov]

I tried but it gives error:

"='" sh.name & "'!" & "$E$3:$E$" & lr
Expected end of statement

Attachment 796562

[jolivanes]

It might help if you show where and as what you qualify sh.
Show your whole code in other words.

[Akbarov]

Solved

Please Login or Register  to view this content.

[Marc L]

Yes, sorry, my bad, badly edited on smartphone ...

[Marc L]

As a reminder, the quotes are mandatory when the sheet name contaiins a space ...

[Akbarov]

Thank you for information