ExcelBanter - Wild Character in String

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

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

- - Wild Character in String (https://www.excelbanter.com/excel-programming/375595-wild-character-string.html)

Himansu

Wild Character in String

Hello everyone,

Is it possible to enter a wild character in a string?
For example:

' select the first worksheet in the workbook
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("JDF%%%%_lot1_sourcecode").Select

** I have multiple worksheets after my process is done.
I want to select the first sheet in the workbook.

-
Thanks,
Himansu

NickHK[_3_]

Wild Character in String

Himansu,
Worksheets(1).select

NickHK

"Himansu" .gbl...

Hello everyone,

Is it possible to enter a wild character in a string?
For example:

' select the first worksheet in the workbook
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("JDF%%%%_lot1_sourcecode").Select

** I have multiple worksheets after my process is done.
I want to select the first sheet in the workbook.

-
Thanks,
Himansu

Himansu

Wild Character in String

Worked! Thanks.

"NickHK" wrote in message
...
Himansu,
Worksheets(1).select

NickHK

"Himansu"
.gbl...

Hello everyone,

Is it possible to enter a wild character in a string?
For example:

' select the first worksheet in the workbook
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("JDF%%%%_lot1_sourcecode").Select

** I have multiple worksheets after my process is done.
I want to select the first sheet in the workbook.

-
Thanks,
Himansu

All times are GMT +1. The time now is 08:50 AM.