Board index » Visual Basic
All times are UTC
How can I get the name of a sheet to work with this information?
Set NameOfSheet = ActiveSheet.Name
doesn't work because Name is no property of ActiveSheet.
How can I do this?
Many thanks in advance,
Timo :)
"He who breaks a thing to find out what it is, has left the path of wisdom" -Gandalf
Dim NameOfSheet as String NameOfSheet=ActiveSheet.Name
-- Clint LaFever http://lafever.iscool.net
> How can I get the name of a sheet to work with this information?
> Set NameOfSheet = ActiveSheet.Name
> doesn't work because Name is no property of ActiveSheet.
> How can I do this?
> Many thanks in advance,
> Timo :)
> "He who breaks a thing to find out what it is, > has left the path of wisdom" -Gandalf
1. Getting the list of Excel Sheet Names using VBA
2. Getting excel sheet names with DAO
3. getting sheet name in excel
4. Getting excel sheet names with DAO
5. getting previous cell values in excel sheets
6. Getting the RIGHT Excel sheet with OLE automation - AddOLEObj
7. how getting data from EXCEL.sheets
8. VB 3.0 PRO/EXCEL/DDE Getting info from different sheets
9. Excel Sheet Name
10. Use VBA to send Task Folder name to an Excel Sheet
11. Accessing Excel Sheet Names in VB 4.0
12. Changing name on Excel sheet
getting the name of the active sheet (Excel)