Thread: Variable refers to a workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BlairH BlairH is offline
external usenet poster
  
Posts: 10
Default Variable refers to a workbook
Excellent. Thanks!

"Jackpot" wrote:

Use the Set statement which assigns an object reference to a variable or
property.

Dim mywkbk as workbook
Set mywkbk = Activeworkbook
Msgbox myWkbk.Name
Msgbox myWkbk.Sheets.Count


Reply With QuoteReply With Quote