-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
worksheet existence vba
-
A
create new worksheet and hyperlink it to a variable cell
Hi I am new to this forum so i hope i am communicating the right thing in order to get help. So i have an excel file containing a complex plan. This file has an overview sheet and project plans. In the overview sheet :column A contains a hyperlinks to other worksheets (1 project plan=1...- andreea_mn
- Thread
- Replies: 1
- Forum: Excel Questions
-
A
check if certain worksheet exists and delete
does anyone know how to check if a worksheet exists called "workingdata" and delete it if it does? If the workingdata worksheet does not exist i just want to carry on with the rest of the things i've coded. i can't use the set worksheet as ... because if it doesn't exist then the whole thing...- asdfasdf
- Thread
- Replies: 5
- Forum: Excel Questions
-
D
vba - check worksheet existence
Hello! I got a listbox which chooses from which worksheet a value should be copied. Now If there is a value in the listbox, where there is no corresponding worksheet, I get an "out of range" error. What I need is a way to check if there is a worksheet called as the choice the user makes to...- davidhasselhoff
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...