Search results for query: *

Does anyone have a template (besides the one on Microsoft's site) that they would be willing to share? Thanks Max

Could someone please tell me how to give a field name(excel 2000) to a cell. I couldn't find it in help files or through a search of the forum. Thanks

I have a spread sheet (worksheet "work") that covers range("a1:x65000"). I am trying to use autofilter and copy a specific column to another sheet. Say i am copying the data in column a on worksheet("work") to the next empty cell in column b on...

I have a flat table of data in excel 2000. The range is made up of 35 columns and and may go up tp 65000 rows. I need to be able to filter the range by three separate columns. Say column A (filter for values > 0), column d (filter for 1), and column w (filter for 2003). The resulting data...

I have a database in excel 2000. I would like to filter the database using the value found in worksheets("criteria").range("a4"). can someone tell me how to do this? thanks

I have a userform with multipage on it. The form is used to transfer information to worksheets("data"). Is it possible to have on of the pages on the multipage to be disabled if a if worksheets("data").range("c10") = 1 Thanks

I have a listbox with several choices for the user to choose. Once an item is selected and the okay button is clicked, the selected item will be placed in a certain cell. My question is: Is there a way to set a default value for the listbox such that a 0 would be placed in the cell if no...

I use the following to enter a date in a cell: worksheets("data").range("d12") = "=TODAY()" It places the date okay, but instead of actually entering the date, it enters the formular. So tomorrow when the date changes, that cell changes to the new date. How do I...

I wrote the following code in excel 2000, win 2000 and it worked. When I try to run it in excel 2002 win xp i get the following message "select method of worksheet class failed" What do I need to change? Private Sub UserForm_Initialize() Sheets("work").Select...

I would like to create a button on my desktop to open excel and open a workbook. For example open excel, and open workbook "statistics". Is this possible? Thanks

I am trying to copy one range to another, but I keep getting the following message "object doesn't support this method or property". Can someone tell me what i am doing wrong? Thanks Sub Extract_RCRdata() 'extracts RCRdata for month/year specified...

Say I use autofilter on column a on sheet1. I would then like to copy the results to column b on sheet two. How do I select the range of the filtered to copy? The first cell will always be a2 on sheet1 but how do you code to find the last cell? I tried using ctrldown arrow, but it does not...

I have an application that gathers information from the user via userforms, the information goes into excel database. When the user completes the last userform, they want to save the form. If the user selects yes, then the info is transferred from the database to a form I have set up on...

Does anyone know where I can find some information on altering the look of forms, command buttons, textboxes, and comboboxes in excel. I have an app that has a lot of userforms and I would like to make the forms interesting to look at. Thanks

Is it possible to filter with the criteria being from an listbox? For instance say there is a column A on worksheet1 with a list of names where a specific name may occur many times. How would you use the name the user selects as the filtering criteria. Thanks

The following code was written in Win 2000 and excel 2000. It will be used on a machine that has Win xp and excel 2002. Is this going to be a problem? I tried it last night. When it got to FirstCell = ActiveCell.Address, it told me it could not find the project or library. Sub...

Is it possible to have the grid lines visible on some rows and columns and invisible on other rows and columns on the same sheet? Thanks

I have a column of money amounts that sre summed. The new amounts are entered from a textbox to a new sheet. The new items are then copied to the column that is being summed. The items that came from the textbox will not add. If i type the same number over the textbox it adds. This is...

I get an error (runtime-error '6': overflow every time the following code is executed. Could someone tell me what the problem is? Dim LastRow As Integer LastRow = sheets("database").Range("A3").End(xlDown).Row sheets("TEMPDB").Range("a3:AI3").Copy...

I just wanted to take the time to thank you all for the help I have received through this forum. Thanks for taking the time to help others out. I want to especially thank Dale Watson. He took several hours out of his busy schedule to help me out on a report I was trying to do. I sent him the...