Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using "contains" or "part" in VBA for Wksheets
Hi. I am new to VBA and trying to write a code for an excel document. In
it, i have a functioning code however ti is tied to a worksheet name with a with and find procedure. I'd like to adjust the code so it would have a contains (if that exists) rather than a constant worksheet name. ie. today it is "Sheet1" but I would also like it to work for "Sheet1 (2)" without readjusting. Any thoughts!!?? Thanks. |
#2
|
|||
|
|||
Using "contains" or "part" in VBA for Wksheets
for each wks in activeworkbook.worksheets
if lcase(wks.name) like lcase("sheet1*") then 'do your stuff else 'don't do it end if next wks You may want to look at InStr in VBA's help, too. newtovba wrote: Hi. I am new to VBA and trying to write a code for an excel document. In it, i have a functioning code however ti is tied to a worksheet name with a with and find procedure. I'd like to adjust the code so it would have a contains (if that exists) rather than a constant worksheet name. ie. today it is "Sheet1" but I would also like it to work for "Sheet1 (2)" without readjusting. Any thoughts!!?? Thanks. -- Dave Peterson |
#3
|
|||
|
|||
Using "contains" or "part" in VBA for Wksheets
Hi Dave.
Thank you. Quick question. What is a "wks?". I'm trying the rest out right now. "Dave Peterson" wrote: for each wks in activeworkbook.worksheets if lcase(wks.name) like lcase("sheet1*") then 'do your stuff else 'don't do it end if next wks You may want to look at InStr in VBA's help, too. newtovba wrote: Hi. I am new to VBA and trying to write a code for an excel document. In it, i have a functioning code however ti is tied to a worksheet name with a with and find procedure. I'd like to adjust the code so it would have a contains (if that exists) rather than a constant worksheet name. ie. today it is "Sheet1" but I would also like it to work for "Sheet1 (2)" without readjusting. Any thoughts!!?? Thanks. -- Dave Peterson |
#4
|
|||
|
|||
Using "contains" or "part" in VBA for Wksheets
I should have included:
dim wks as worksheet at the top of the code. I wanted to use a variable that could represent a worksheet so that I could loop through all the worksheets. Sorry, newtovba wrote: Hi Dave. Thank you. Quick question. What is a "wks?". I'm trying the rest out right now. "Dave Peterson" wrote: for each wks in activeworkbook.worksheets if lcase(wks.name) like lcase("sheet1*") then 'do your stuff else 'don't do it end if next wks You may want to look at InStr in VBA's help, too. newtovba wrote: Hi. I am new to VBA and trying to write a code for an excel document. In it, i have a functioning code however ti is tied to a worksheet name with a with and find procedure. I'd like to adjust the code so it would have a contains (if that exists) rather than a constant worksheet name. ie. today it is "Sheet1" but I would also like it to work for "Sheet1 (2)" without readjusting. Any thoughts!!?? Thanks. -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Using "contains" or "part" in VBA for Wksheets
Dave,
I ended up using "activesheet" rather than specify a worksheet. Working like a charm. Thanks. "Dave Peterson" wrote: for each wks in activeworkbook.worksheets if lcase(wks.name) like lcase("sheet1*") then 'do your stuff else 'don't do it end if next wks You may want to look at InStr in VBA's help, too. newtovba wrote: Hi. I am new to VBA and trying to write a code for an excel document. In it, i have a functioning code however ti is tied to a worksheet name with a with and find procedure. I'd like to adjust the code so it would have a contains (if that exists) rather than a constant worksheet name. ie. today it is "Sheet1" but I would also like it to work for "Sheet1 (2)" without readjusting. Any thoughts!!?? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|