Thread: Set Active Sheet as Variable
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Set Active Sheet as Variable
try:
Set Log = WrkBk.Sheets("Sheet1")

be sure not to put any dot at the end of the line
Reply With QuoteReply With Quote