Thread: userinterfaceonly=True fails with this code!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
  
Posts: 274
Default userinterfaceonly=True fails with this code!
Hi All,

Problem solved, but not sure l understand why:

Dim SourceSheet As Worksheet

but

Set SourceSheet = Sheets("MySheet")

should be

Set SourceSheet = Worksheets("MySheet")

Regards

Michael

Reply With QuoteReply With Quote