Search results for query: *

Sorry It is for a Residential Construction project, slab on grade, combination flat and sloped tile roof. The Exterior finish is Stucco and it is 2600 sf. Thanks

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

Thanks for the quick response PHV. I am sorry I was not clear enough in my question. I am actually trying to do it manualy and not with code. Thanks

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...

Thanks guys. I think I can use the autofilter method, but one of my filter criteria is the value found at worksheets("work").range("b12"). I do not know how to do that part. Thanks

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

Thanks anyway, but i finally got it

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

skip 0 is the first item in the listbox. the listbox is part of a form that the user fills out. once they are finished with the form, they click okay, and the information is transfered to a worksheet. 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...

Rob At first I tried just using the function, but as you stated, I tried it exactly as suggested and it worked fine. However, I need a date without the time. Any suggestions? Thanks

thanks for your reply skip, but using "now" does the same thing. when the actual date changes, the date in the cell changes also. i want the date in the cell to stay the same after it has been entered. thanks

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...

One thing i forgot. When you are entering the column widths in the properties, you separate the values with ; Max

To set what columns are visible: click on the listbox, and go to the column width in the properties. Set the width for width for the first column(when i made my table for loading I put the column I wanted to see when form was loaded in the first column)to what value it takes to show the...

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...