Code to set variable

**rizmomin** · 11-04-2017, 12:31 PM

Hello:

I have Sheet name Data, cell C2 = "PERSONAL.XLSB!Test

I have set as below in my code but gives error in below statement.

Macro1 = Data!Range("C2").String

Please help correct this

Please let me know if you have any questions.
Thanks.

Riz

**Mumps1** · 11-04-2017, 12:38 PM

I'm not sure what you are trying to do but maybe:

Please Login or Register  to view this content.

**6StringJazzer** · 11-04-2017, 12:39 PM

Try

Please Login or Register  to view this content.

**kev_** · 11-04-2017, 12:40 PM

Please Login or Register  to view this content.

**rizmomin** · 11-04-2017, 12:41 PM

Hello 6StringJ:

Thanks a lot, works

Riz

Code to set variable

LinkBack

Thread Tools

Rate This Thread

Display

Code to set variable

Re: Code to set variable

Re: Code to set variable

Re: Code to set variable

Re: Code to set variable

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Code to convert one variable as an Integer to a new variable as a month name

[SOLVED] Represent (define?) a section of code with a variable (shorten long code lines)?

[SOLVED] New Error/Old Code - Run Time Error 91; Object variable or With block variable not set

[SOLVED] Error in a Code. Object variable or With block variable not set????

[SOLVED] Excel VBA error code 91: Object variable or with block variable not set

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

Error Code 91 Object Variable or With Block variable Not Set

Bookmarks

Bookmarks

Posting Permissions