View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curt Curt is offline
external usenet poster
 
Posts: 469
Default not completeing mission

Worksheets("Data").Activate
Range("b4:m4").Select
Selection.ClearContents
Range("b4").Select
Worksheets("MailE").Activate
Range("b4:m4").Select
Selection.ClearContents
Range("b4").Select ' don't need this right'

This is from a userform option button. Problem when clicked it clears
contents and leaves row blocked until you close userform. I am missing
something.
Thanks to all the community All Of you are a great asset