Thread: Copy from active sheet and paste into new sheet using info from cell in active
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Copy from active sheet and paste into new sheet using info from cell in active
We can't all be great typists <g

--
Regards,
Tom Ogilvy

"Ingve" wrote in message
ps.com...
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