If a workbook has only 1 worksheet then

  • Thread starter FIRSTROUNDKO via OfficeKB.com
  • Start date
F

FIRSTROUNDKO via OfficeKB.com

Hi,

Please can somebody tell me what the correct format for

"If a workbook has only 1 worksheet then"

I think I may need to use the count function

Regards

Darren
 
F

FIRSTROUNDKO via OfficeKB.com

ok I solved it,

If ActiveWorkbook.Worksheets.Count = 1 Then
 
F

FIRSTROUNDKO via OfficeKB.com

ok I solved it,

If ActiveWorkbook.Worksheets.Count = 1 Then
 
F

FIRSTROUNDKO via OfficeKB.com

ok I solved it,

If ActiveWorkbook.Worksheets.Count = 1 Then
 
Top