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. |