View Single Post
  #2   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

1. should be:
Set QuoteSht = ActiveSheet
(instead of AvtiveSheet)

2. MsgBox QuoteSht
what do you need this message box for? you only can place a string in
MsgBox (sth. like QuoteSht.Name)
QuoteSht cannot be placed in a MsgBox since it is an object