Range does not require a qualifier so I don't know why you're finding that
it does. From Help:
"When used without an object qualifier, this property is a shortcut for
ActiveSheet.Range (it returns a range from the active sheet"
--
Jim
"Rob" <NA wrote in message ...
when creating some code, via the record macro function I find that
sometimes, for it to run succesfully, I need to add "Application"
immediately before some of the lines.
eg. Range ("A1") would become Application.Range ("A1") for that line to be
accepted.
Can someone tell me why, and what the rule is here?
Rob
|