VBA for Hiding/Unhiding columns

[Theangelp]

Hi, I am using the code below in order to hide/unhide columns and so update a chart that is sourcing the data from said columns. It works OK on my first worksheet but when I've copied it to the second and changed the Range name it doesn't work on the second. Can anyone help?

Thanks in advance,

A.

Please Login or Register  to view this content.

[Logit]

Try specifying the Sheet by using "ActiveSheet" ?

Please Login or Register  to view this content.

[Leith Ross]

Hello Logit,

In VBA if a Range object is not prefaced with the name of the Worksheet it is on, the assumption is the ActiveSheet.

[kasan]

Theangelp, your code worked fine for me. Do you know line that stops your code? Did you try step-by-step test?
My guess - something wrong with named range

[Theangelp]

Thanks all.

Kasan - it's not stopping; it's not even starting!. On the initial worksheet when I select the data I want shown on the chart (from a drop-down) the code works fine by hiding/unhiding the relevant column, however when I do the same thing on the second worksheet nothing happens (unless I go into the code and hit Run).

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[zbor]

You said that you've change range name and you refering to Range("FIIndexRange") in the code.

P.S. You don't need to give me reputation for reminding on rules. It won't make me more tolerant

[Theangelp]

Thanks zbor.

Yes, the named range on the first worksheet has a different name.

[kasan]

Theangelp it's not even starting!. nothing happens (unless I go into the code and hit Run).

Just to be sure - do you have Worksheet_Calculate() code in each sheet`s code or just in one sheet code?

[Theangelp]

I have it in each sheet's code.