Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm running an Access Database that creates worksheets in an Excel sheet.
The sheet is automatically named based on one of the criteria from the DB. The problem I'm having is that I need to check if there is already a sheet in the workbook with the same name as the one the DB is trying to use. I need this to be part of the DB's coding, but can't seem to figure out a chunk of code to to find the name of a worksheet. Any thoughts out there? I tried the below, but that didn't work. Sheets("Name_of_Sheet").Count - Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Info from sheet 1 and removing only those rows from sheet | Excel Discussion (Misc queries) | |||
Finding last row of every sheet | Excel Programming | |||
Finding data of one sheet in another sheet | Excel Programming | |||
Better way of finding last row on sheet | Excel Programming | |||
Finding last sheet | Excel Programming |