Hi
I have a sheet with a list of sheet names (some, but not all, of the other sheets in the workbook) in column A ('Sheet1' A:A). The list length can vary, but should usually be anywhere between 1-10 entries.
What I would like to do is set a string variable in VBA, then have the code search the sheets that are listed in column A of Sheet1 for that variable.
The basic logic that I am think of is something like:
Code
Dim FindThis As String
FindThis = "Example"
'Get all of the sheet names from 'Sheet1' A:A
'Search tab1
'if "Example" found, set sheet name and row as variables. If not then,
'Search tab2 ....... and so on
Thanks for all the help.