(Solved) – VBA: Is it possible to use cell values to activate a similarly named tab?

(solved)-–-vba:-is-it-possible-to-use-cell-values-to-activate-a-similarly-named-tab?

This may be pretty basic but I haven’t had success yet.

I have a block of data within a range on workbook 1.
Each cell has a value that corresponds to tab names of workbook 2.

How can I use these cell’s value to activate the proper corresponding tab on workbook 2?

The code is on another computer sorry no examples right now.

I tried so far setting a variable equal to the cell’s value, but can’t seem to translate it into a workbook object for calling the tabs.

thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *