In my macro, I want to delete a certain sheet name. But if I do this ( Sheets("sheet1").Delete ), and the sheet does not exist, I get an error. How do I check to see if the sheet exists or not?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_102...
suppose i have 4 textboxes and 1 command button.
Private Sub command1_Click()
text3.text = val(text1.text) + val(text2.text)
text4.text = val(text3.text)
End Sub
What i...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_11714338.html
Zones:
Visual BasicDate Answered: 07/30/2001 Grade: A Views: 0
I need
1:
Save a table by clicking a button into another table within the same Database (I.e. Automatically do what the Make Query table could do. (Enter preferred table name))
2:
Load any...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20006119.html
Zones:
MS AccessDate Answered: 12/22/2000 Grade: C Views: 0
I have asked this question before but I forgot to ask the second part of the problem.
I need to save the table as an excel sheet within an existing Excel file (With other sheet data of course).
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20014408.html
Zones:
MS AccessDate Answered: 01/04/2001 Grade: B Views: 0
I have a multi-sheet workbook that creates a budget to be used in another application.
The data we need is in some rows of some sheets. We want to check each row of each sheet and, if there is...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_201...
I would like to override the default placement of a propertypage on a propertysheet.
(I want some buttons above the Tab section).
Is there an easy way to do this?
http://www.experts-exchange.com/Programming/System/Windows__Programming/MFC/Q_20286586.htm...
Zones:
Windows MFCDate Answered: 01/02/2003 Grade: A Views: 0
Hello all,
Excel's built in "Apply Names" feature is great at putting in names from the current worksheet, but won't apply names that come from other sheets.
Does anyone know how to do this?
...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_203...
I need to make a contact sheet in PS 7 using the file name for each picture without including the file extension. This worked fine in PS 5 and 6 but in PS 7 the .tif is always included - is there a...
http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Adobe_Photoshop...
I have a financial data sheet in excel that needs to be connected with a Visual Basic inetrface. Can anybody help me with this?
http://www.experts-exchange.com/Programming/Misc/Q_20405401.html
Zones:
ProgrammingDate Answered: 09/18/2003 Grade: B Views: 0
I'm a newbie so this is probably easy. I have names stored in an excel sheet I need these names to show up in a list box. On the same note is there a way to do the same with a text file? Thanks for...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20463325.html
Zones:
Visual BasicDate Answered: 01/21/2003 Grade: A Views: 0
