Thread: What's the correct format to check the name of a sheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
  
Posts: 1,089
Default 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



Reply With QuoteReply With Quote