Selection and Areas
No Jac. Intellisense will not be provided for selection.
You can substitute a specific object and build your code, then go back and
replace it with selection.
or if you know what the selection will be (and you more than likely will),
define a variable to that type
Dim rng as Range
set rng = Selection
' now use rng and you will get the intellisense.
If you are recording your code, then you need to clean it up anyway.
--
Regards,
Tom Ogilvy
"Jac Tremblay" wrote in message
...
Hi Chip,
Thank you very much for this precious help. It works fine for me.
For the Selection object, is there a way to restrict the range of objects
so that Intellisense is provided? And also, is there a way to check the
properties or methods availaible for a specific case of the Selection
object, like the selection of worksheet cells?
Thanks again for your help.
|