I get a subscript error when trying to assign a worksheet to a variable
The Sheet name is correct (line3 . . . = "Value")
But line 4 throws an error 9
I am clearly missing something basic here.Please Login or Register to view this content.
TFAI
I get a subscript error when trying to assign a worksheet to a variable
The Sheet name is correct (line3 . . . = "Value")
But line 4 throws an error 9
I am clearly missing something basic here.Please Login or Register to view this content.
TFAI
Is that the exact code? It looks like it should work -- except for the Unicode "left quote" and "right quote" characters (characters 8220 and 8221). If that is your exact code, you need to use regular quote characters in VBA (character 34).
Originally Posted by shg
Thank you
Well spotted
That's what copy and paste and do to you!!
(Seriously unhelpful error message - again!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks