Macro that Ignores Tab/Sheet Name

[Bkisley]

I have a macro that is written to pull data from a different tab. This macro will not work if/when a different user changes the name of the tab. How can I change my code to pull the same data regardless of what that tab name is.

Portion of current macro
Selection.Copy
Sheets("Financial Model").Select
Range("C14").Select


So if someone changes the tab name of Financial Model to anything other than that, the macro will not work.
What can I do to the above macro that will allow me to pull the same data from that tab regardless of the name.
When I open up the VBAProject it is called Sheet12 (Financial Model)

I have already tried to change it to ....... with no success
Selection.Copy
Sheets("Sheet12").Select
Range("C14").Select


Please help!

 

[Norie]

Try this.

Sheet12.Select

 

[AlphaFrog]

Change this...
Sheets("Financial Model").Select

To this...
Sheet12.Select


Sheet12 is the sheet's code name and that doesn't change.

 

[Bkisley]

worked PERFECTLY!

Thank you

Change this...
Sheets("Financial Model").Select

To this...
Sheet12.Select


Sheet12 is the sheet's code name and that doesn't change.

 

[Rick Rothstein]

Sheet12 is the sheet's code name and that doesn't change.[/COLOR]

...unless the user physically changes the sheet's Name property via the Properties Window which one hopes they wouldn't do, of course. :wink: