Using Variable to call Worksheet

**mlreinhardt74** · 08-12-2013, 04:14 PM

Hi all! I am new to this forum and I am very excited about all of the talent that I see here. It has been years since I have coded and now I am just starting again. I am trying to use a vlookup to find the name of a worksheet that I want to call. I have the lookup working as I have a msgbox that shows me the name of the worksheet is stored in the variable, but for some reason it will not allow me to select the sheet so that I can run the rest of the macro. The very bottom line is where I keep striking out. I have looked at so many posts and tried so many different variations that I am now really confused. Any help you can give me would be greatly appreciated.

Please Login or Register  to view this content.

Thanks in advance for your miraculous (all be it easy for you) answer!

**TMS** · 08-12-2013, 07:38 PM

You've defined Select_sht as a Workbook.

Regards, TMS

**mlreinhardt74** · 08-13-2013, 10:00 AM

I have tried multiple defining it as a multitude of things. Can someone tell me what I should define it as so that this will work?

**mikerickson** · 08-13-2013, 10:03 AM

The variable Select_Sht should be data type Worksheet.

Then, after your code, the line

Please Login or Register  to view this content.

will select that sheet.

**mlreinhardt74** · 08-13-2013, 11:29 AM

Hi Mikerickson. I thought about what you said after I read your first post and changed it to worksheet. I also had added the Select_Sht.Activate before reading your last post. You have been a tremendous amount of help. I really appreciate it! It works great now. Thank you!

**TMS** · 08-13-2013, 01:23 PM

Not wishing to be picky, but the first response was mine.

Maybe I was being too subtle, but I thought it might click that if you were trying to access a worksheet, defining the variable as a workbook might just cause a problem.