(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.


Leave a Reply

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