Referencing a different tab in VBA code

[davo3286]

Trying to reference a different tab/sheet to the current sheet with code on.

Please Login or Register  to view this content.

Name of the sheet highlighted in yellow text.

Thanks

[Fluff13]

How about

Please Login or Register  to view this content.

[davo3286]

That's not working unfortunately but I appreciate you looking into it for me.

[romperstomper]

It will work assuming that is what is shown on the sheet tab. What's happening?

[Fluff13]

That's not working unfortunately

In what way?

[davo3286]

The dial is not moving at all so it's not picking up the reference of "F2" from "Speedometers" tab. It was working when the speed dial was on the same tab as the cell I'm referencing but I'm currently building a Dashboard so needed to cut and paste the chart over.

[Fluff13]

Can you supply a sample workbook.

[romperstomper]

If you're not getting an error, then the code is correct, so something else is at play. Where is the cell that you are changing to trigger the code? If it's on the Speedometers sheet, then the code needs to be in that sheet and it's the other sheet reference that needs to change.