Thread: Copy from active sheet and paste into new sheet using info from cell in active
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ingve Ingve is offline
external usenet poster
  
Posts: 3
Default Copy from active sheet and paste into new sheet using info from cell in active
Thanks a lot Tom!,

I got an error on this line:
set sh1 = Worksheets(sh.Range("B7'))

But I quickly found out that replacing the ' after B7 with " did the
trick:-)

Regards
Ingve

Reply With QuoteReply With Quote