Indexing a activecell to a range

[Sriramroxx]

I'm indexing Activecell to a range and selecting it with the indexed name.
Range ("rng").select is not working. Why?

Please Login or Register  to view this content.

[BanginMyHeadOnMyDesk]

Because your code is trying to call on rng via a string variable rather than the range object you've set it as.

Should be:

Please Login or Register  to view this content.

Rather than:

Please Login or Register  to view this content.

Beth.

[Sriramroxx]

Thanks. I already said that rng as range. So I dont need to specify it.

[BanginMyHeadOnMyDesk]

I didn't say you did need to specify it, I said your code was calling on it incorrectly. Purely a syntactical error.

Anyway, glad it's solved and thanks for the rep.

Beth.