[dba-Tech] Excel question about "current" sheet

Hi Susan

That depends ... the collection Sheets can hold objects of type Chart or Worksheet.
So if you operate with only one type of sheet, you should refer to that specific type.

/gustav

>>> ssharkins at setel.com 08-04-2007 23:58 >>>
That got me close enough -- ActiveSheet.Name

I had checked for ActiveWorksheet, but then it hit me -- Excel uses the term sheet, not worksheet.

Thanks!

Susan H.  


Hi Susan

ActiveWorksheet?

/gustav

>>> ssharkins at setel.com 08-04-07 22:48 >>>
Using VBA, is there a generic way to express "the current sheet" instead of
hard-coding a sheet by name? 

Susan H.