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...
Zones:
MS OfficeDate Answered: 03/12/2002 Rating: 7.6 Views: 0
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 Rating: 7.6 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 Rating: 4.6 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 Rating: 6.0 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...
Zones:
MS OfficeDate Answered: 09/21/2001 Rating: 7.8 Views: 0
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 Rating: 7.8 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...
Zones:
MS OfficeDate Answered: 08/24/2002 Rating: 7.8 Views: 0
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 Rating: 7.0 Views: 0
I have the task of collecting machine status data on several machines at work. Currently I have users inputing Start and Stop times as general date format in two fields of a table, actually throug...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20497098.html
Zones:
MS AccessDate Answered: 02/09/2003 Rating: 7.0 Views: 0
