Use variable in worksheet name

**ndjustin20** · 01-09-2020, 04:43 PM

Hello,

I have the following code and keep getting an runtime error 9 Subscript our of range error. I've tried using the codename and the sheet name. Neither seems to work though. I've tested the variable and it does show the correct sheet name and I've tried other sheet names also. If I hard code in the sheet name it works fine. For some reason I cannot get the value of the variable to work within the Sheets object parenthesis.

Please Login or Register  to view this content.

**ndjustin20** · 01-09-2020, 05:42 PM

I finally got it. The ActiveX dropdown returns a string already. I was trying to convert a string to a string and it was actually leaving it as an integer then as originally declared to begin with. I hope that isn't as confusing as it sounds

I wish the compiler would have just thrown a type mismatch error when I tried to use CStr on the string I was getting from the dropdown.

Thanks again!!

**moktr** · 01-09-2020, 08:57 PM

Hello Mr. Ndjustin20, I have the following code to make hide & unhide shape. It working perfectly but when this worksheet to make 'share' then it not working. Plz help me..

Please Login or Register  to view this content.

**jeffreybrown** · 01-09-2020, 09:03 PM

Hi moktr,

Two things! First, please use code tags when posting code, and second, if you have a question please post your question in your own thread.

**moktr** · 01-10-2020, 09:17 AM

Hi Mr. thanks for reply. My main problem is, this macro not work in shared workbook.

Use variable in worksheet name

LinkBack

Thread Tools

Rate This Thread

Display

Use variable in worksheet name

Re: Use variable in worksheet name

Re: Macro not work in shared workbook

Re: Use variable in worksheet name

Re: Use variable in worksheet name

Thread Information

Users Browsing this Thread

Similar Threads

Use of variable in a worksheet cell to refer to variable tabs on a second worksheet

[SOLVED] Save the name of a Worksheet into a variable and then use that variable as worksheet name

[SOLVED] Worksheet: Object variable or With block variable not set?

[SOLVED] Replacing a referenced worksheet name with a variable worksheet index number.

[SOLVED] TypeName limitation: How to distinguish Worksheet Variable from Workbook variable

Error "Object variable or With block variable not set" returning worksheet to function

[SOLVED] Store variable in worksheet and use that variable in VBA code

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions