Var use

[Nahum]

Hi all

This part of my code does not work, probably wrong use of vars i and j.
Raw 15 of the code " ActiveChart.SeriesCollection(1).XValues = "='S2p Scan'!$A$i:$A$j" " is the problematic one.

thx

Please Login or Register  to view this content.

[martindwilson]

code tags please

[Nahum]

code tags ??

[martindwilson]

read the rules before posting
rule #3. Use code tags around code
http://www.excelforum.com/forum-rule...rum-rules.html

[Cutter]

@ Nahum

Welcome to the forum.

Please notice that code tags have been added to your post(s). As martindwilson has pointed out, the forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[Nahum]

Thanks for the code tagging.
Is there an answer to my original question?

[shg]

Please Login or Register  to view this content.

[Nahum]

Thank you, it was very helpful!