Tweak155
Lifer
First I will tell you my goal, then I will tell you how I tried to do it.
Goal:
To see if a worksheet with a certain name exists in a DIFFERENT workbook (i.e the worksheets are not in the SAME workbook).
Attempt:
I tried to reference the name of the worksheets using:
[BOOK]VARIABLE.Sheets(x).Name
VARIABLE is written in text
But that beginning reference seems to only work in a cell inside a sheet. What is the vb syntax? Thanks ahead of time.
Goal:
To see if a worksheet with a certain name exists in a DIFFERENT workbook (i.e the worksheets are not in the SAME workbook).
Attempt:
I tried to reference the name of the worksheets using:
[BOOK]VARIABLE.Sheets(x).Name
VARIABLE is written in text
But that beginning reference seems to only work in a cell inside a sheet. What is the vb syntax? Thanks ahead of time.
