I need to be able to set a Range object. In my VBA, I'm selecting Range("B2"). Now I need to set a new Range object, called Rng, to the range. Every time I try to set it, though, I get the value of the range, not a range object, even though Rng is DIMmed as a Range.
If I change Rng to an Object, and try the statement Set Rng = CreateObject("Excel.Range"), I get the error "ActiveX component can't create object." If I use Set Rng = CreateObject("Excel.Application"), however, it does work.
When I look in my Object Browser, I only find CreateObject in the VBA.Interaction class, nowhere else.
Thanks for taking the time to reply. I was in crunch mode, so I changed Rng to a string and used it that way. The Range object was something I was experimenting with, and I guess I still haven't perfected it. Oh, well. There's always next time.