Referencing a cell from another worksheet in VBA

[a-man]

Hi,

I have a drop down list in sheet 'Reinforcement' located in cell G4. When this cell selection changes, VBA code hides/unhides certain rows.

In sheet 'summary', i would like to reference the drop down list in 'Reinforcement' in cell G4 to hide/unhide rows. Below is the successful code used when hiding/unhiding rows in 'Reinforcement':

Please Login or Register  to view this content.

How do i change this code so that it refers to G4 in the 'Reinforcement' sheet when the code is running in the 'summary' sheet?

[HaHoBe]

Hi, a-man,

should only be Sheet Reinforcement be monitored? If so you could add thee same lines to hide/unhoide but add a qualifiers for sheet Summary there like

Please Login or Register  to view this content.

If the code should run on either shee I would set a Variable for teh worksheet on which it shuould be hgandled like

Please Login or Register  to view this content.

Assuming that both sheets are protected with the same password (otherwise use a variable/array to handle the indivdual passwords).

Ciao,
Holger

[a-man]

Holger - Once again, thank you!