Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test worksheet name
Hallo,
I would need to test whether the active sheet has one of the name from several possibilities. I tried the simple code below, but it is ending with error. Sub worksheet_name_test() Dim wks As Worksheet If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = "Rbn" Then MsgBox "Correct sheet was not chosen!", vbCritical End If End Sub Thank you in advance for any suggestions. Petr Duzbaba |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test worksheet name
Hi Petr
Try this one With ActiveSheet If Not .Name = "Revenue" Or .Name = "SF Revenue" _ Or .Name = "Rbn" Then MsgBox "Correct sheet was not chosen!", vbCritical End If End With -- Regards Ron de Bruin http://www.rondebruin.nl "Petr" wrote in message om... Hallo, I would need to test whether the active sheet has one of the name from several possibilities. I tried the simple code below, but it is ending with error. Sub worksheet_name_test() Dim wks As Worksheet If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = "Rbn" Then MsgBox "Correct sheet was not chosen!", vbCritical End If End Sub Thank you in advance for any suggestions. Petr Duzbaba |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test worksheet name
Petr,
on behalf of all Dutchmen: thanks for getting us into the quarterfinals, I hope you'll regret it in the finals :-) Dim wks As Worksheet If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = if you just want to test the activesheet, you dont need the wks variable = use instead activesheet.name etc.. however you probably included the wks variable to keep your code short. BUT you forgot to assign it a value (or in this case an object) dim wks as worksheet SET wks = activesheet ....your code alternatively use a select case statement: select case lcase$(activesheet.name) case "revenue","sf revenue","rbn" 'ok case else msgbox "Please select a Revenue sheet!", vbCritical end select keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool (Petr) wrote: Hallo, I would need to test whether the active sheet has one of the name from several possibilities. I tried the simple code below, but it is ending with error. Sub worksheet_name_test() Dim wks As Worksheet If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = "Rbn" Then MsgBox "Correct sheet was not chosen!", vbCritical End If End Sub Thank you in advance for any suggestions. Petr Duzbaba |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test worksheet name
Hi keepITcool
on behalf of all Dutchmen: thanks for getting us into the quarterfinals, I hope you'll regret it in the finals :-) Here is a nice picture for the English fans<g http://www.rondebruin.com/beckss.jpg -- Regards Ron de Bruin http://www.rondebruin.nl "keepITcool" wrote in message ... Petr, on behalf of all Dutchmen: thanks for getting us into the quarterfinals, I hope you'll regret it in the finals :-) Dim wks As Worksheet If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = if you just want to test the activesheet, you dont need the wks variable = use instead activesheet.name etc.. however you probably included the wks variable to keep your code short. BUT you forgot to assign it a value (or in this case an object) dim wks as worksheet SET wks = activesheet ...your code alternatively use a select case statement: select case lcase$(activesheet.name) case "revenue","sf revenue","rbn" 'ok case else msgbox "Please select a Revenue sheet!", vbCritical end select keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool (Petr) wrote: Hallo, I would need to test whether the active sheet has one of the name from several possibilities. I tried the simple code below, but it is ending with error. Sub worksheet_name_test() Dim wks As Worksheet If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = "Rbn" Then MsgBox "Correct sheet was not chosen!", vbCritical End If End Sub Thank you in advance for any suggestions. Petr Duzbaba |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test worksheet name
If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = "Rbn"
Then If wks.Name < "Revenue" Or wks.Name < "SF Revenue" Or wks.Name < "Rbn" Then or try with AND If wks.Name < "Revenue" and wks.Name < "SF Revenue" and wks.Name < "Rbn" Then -- Don Guillett SalesAid Software "Petr" wrote in message om... Hallo, I would need to test whether the active sheet has one of the name from several possibilities. I tried the simple code below, but it is ending with error. Sub worksheet_name_test() Dim wks As Worksheet If Not wks.Name = "Revenue" Or wks.Name = "SF Revenue" Or wks.Name = "Rbn" Then MsgBox "Correct sheet was not chosen!", vbCritical End If End Sub Thank you in advance for any suggestions. Petr Duzbaba |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merged Cells in Worksheet, Test for | Excel Discussion (Misc queries) | |||
If a worksheet name is = to test then a msgbox appears | Excel Discussion (Misc queries) | |||
Test for Worksheet | Excel Programming | |||
How can I test when any worksheet within a workbook is selected | Excel Programming | |||
Test to see if a worksheet exists thanks, Chip | Excel Programming |