Thread: VBA question - Type Mismatch
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud[_2_] Bill Renaud[_2_] is offline
external usenet poster
  
Posts: 117
Default VBA question - Type Mismatch (CurrentRegion property)
Now I remember what the side effects are when using the CurrentRegion
property (verified with a demo program). If you attempt to set a range
variable to a range using the CurrentRegion property, the
Worksheet_SelectionChange event fires (Excel 2000 SP-3). This does not occur
if you use the UsedRange property.
--
Regards,
Bill


Reply With QuoteReply With Quote