Dynamic Sheet Name in VBA

Hello,

I need some pointers about how to correctly reference a sheet name based from a cell value. I currently have two sheets for example: 1. "Home" 2. "Summary 1".

On "Home" in cell H1 will be the name of the "Summary" tab (cell H1: "Summary 1"). I am trying to use VBA to reference that text and use it for a dynamic sheet name in the code.

Please Login or Register  to view this content.

In the live workbook there are 8 sheets (Summary 1, Summary 2, Summary 3, etc). The above is just modified from a macro recorder so if there is a better looping formula I am interested to see how that works. Or just how to dynamically reference a sheet name per the above.

Thank you for any thoughts or suggestions.

Thank you for reading!

A little more difficult (at the beginning of learning), but faster:

Please Login or Register  to view this content.

Artik

Thank you both and it is working now. I was forgetting to divide the worksheet reference from the range. I also should not have relied on macro recorder so heavily hahaha. I thought it would be a bit quicker at first . Thank you both again.