setting a range as a variable

**Zealotwraith** · 07-09-2013, 12:01 PM

Good day,

I want to select a different range based on an if statement,

Im having issues with the Range as variable, its not taking a value,

Please Login or Register  to view this content.

**JosephP** · 07-09-2013, 12:02 PM

you need to use set

Please Login or Register  to view this content.

**shg** · 07-09-2013, 12:03 PM

Object variables require Set, not Let:

Please Login or Register  to view this content.

**Zealotwraith** · 07-09-2013, 12:14 PM

the compiler accepts it, however when executing i get the error "Mehtod 'Range' of object '_ Globa'l Failed

when trying to select it,

Please Login or Register  to view this content.

**JosephP** · 07-09-2013, 12:17 PM

RAC is a Range object not the name/address of a range so

Please Login or Register  to view this content.

assuming the correct sheet is active

**Zealotwraith** · 07-09-2013, 12:27 PM

thanks! ^^

Re: setting a range as a variable