ExcelBanter - What's the correct format to check the name of a sheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - What's the correct format to check the name of a sheet? (https://www.excelbanter.com/excel-programming/361641-whats-correct-format-check-name-sheet.html)

Mikke

What's the correct format to check the name of a sheet?

If ActiveWorkbook.ActiveSheet = "CAR - Auction Detail" Then
CAR1.Range("W2").Offset(i, 0).Value = sImp

Trevor Shuttleworth

What's the correct format to check the name of a sheet?

ActiveWorkbook.ActiveSheet.Name

Regards

Trevor

"Mikke" wrote in message
oups.com...
If ActiveWorkbook.ActiveSheet = "CAR - Auction Detail" Then
CAR1.Range("W2").Offset(i, 0).Value = sImp

Mikke

What's the correct format to check the name of a sheet?

thank you

Trevor Shuttleworth

What's the correct format to check the name of a sheet?

you're welcome

All times are GMT +1. The time now is 01:31 PM.