View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
John Wirt[_5_] John Wirt[_5_] is offline
external usenet poster
 
Posts: 18
Default Declaring a Public variable as a Range and its lifetime

Cool,
Thanks again.
Re-declaring the module level variable, rngDst, in the procedure was a
mistake.
OK, using sensible notation (intColor, not rngColor for an interger
variable).is sensible.
Yes, I got lazy and used "Selection." A bit sloppy.
It works.
John