Macro to get sheets name to select via cell value

**LeeBillington** · 05-05-2021, 09:36 AM

Afternoon,

Is there anyway to get a macro to get a sheets name to select via a cell value

so like Sheets ("Report!D1").select , But "Report!D1" would represent a sheet name to select in the cell D1 in sheet Report

thanks

**KOKOSEK** · 05-05-2021, 10:15 AM

Please Login or Register  to view this content.

**LeeBillington** · 05-05-2021, 10:19 AM

You legend! thank you I appreciate it.

**KOKOSEK** · 05-05-2021, 10:40 AM

If You are happy with solution, please use Thread tools and mark thread as SOLVED.

Macro to get sheets name to select via cell value

LinkBack

Thread Tools

Rate This Thread

Display

Macro to get sheets name to select via cell value

Re: Macro to get sheets name to select via cell value

Re: Macro to get sheets name to select via cell value

Re: Macro to get sheets name to select via cell value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to select sheets regards of sheet name

[SOLVED] Macro to select cell A1 in all visible sheets

Macro to search column B in select sheets for value.

Creating a macro to print only the sheets and portion of sheets that i select.

[SOLVED] Select All Sheets With Names Beginning With Specified Value In Macro

Macro to select certain sheets then perform part of other macro on them only

Select all sheets in a macro

Bookmarks

Bookmarks

Posting Permissions