| Thread | Last Post | Replies |
|
| Copy A Named Range To a Different Sheet | 13 Apr 2008 04:50 GMT | 4 |
I have 2 sheets: "Input" and "Budget". The source list is a named range called "NameSource" (D3:D839) which is the list that the new names are being added. Special problem: the names are not in any particular order and they
|
| test if a value is in a range of values | 13 Apr 2008 04:23 GMT | 1 |
I am trying to write a formula that tests a cell value to see if it matches values in a range of values and returns either true or false. Any help would be greatly appreciated. Josh
|
| Checking to see if file already open | 13 Apr 2008 03:55 GMT | 1 |
I've already posted this on Excel Tip, but no answer. Link: http://www.excelforum.com/showthread.php?p=1905267#post1905267 This routine is used to open another Excel File in a SEPERATE INSTANCE of Excel.
|
| Retreive a variable | 12 Apr 2008 21:43 GMT | 5 |
Is it possible for my UserForm code to retrieve a variable declared and set in the main procedure? I am testing to see if the code is run on my computer or not. I already have this Boolean value set in the main procedure but I do not see how to
|
| ComboBox | 12 Apr 2008 20:36 GMT | 2 |
I'm trying to select the entire text in a combobox when the combbox is dbl clicked. The sample I'm using at: http://www.contextures.com/xlDataVal10.html
|
| MS EXCEL (NEED HELP) | 12 Apr 2008 20:00 GMT | 4 |
We have a very extensive application that requires the use of Ms excel to run. We are getting ready to launch our product to the public but we are very concerned about protecting our worksheets and projects etc. We have very extensive passwords and scrambling etc. We have found ...
|
| Excel VBA macro to encrypt a Workbook or Spreadsheet | 12 Apr 2008 19:58 GMT | 3 |
I've created a button in a spreadsheet that, when clicked, will encrypt and compress a Workbook using IZArc's command line tool. Unfortunately, this requires downloading and installing IZArc software. I would rather use an Excel built-in function that would encrypt and compress a ...
|
| Application wait question | 12 Apr 2008 19:21 GMT | 4 |
I'm having some issues with pausing a macro to allow data to load. I have a table created from an imported web query, and my macro refreshes the query and then makes some adjustments to the new data: Sub NewData()
|
| Decimal question in variable? | 12 Apr 2008 18:29 GMT | 1 |
I would like to know if it exists a function to round up or down a three or more decimal at only two, I am not talking about the content of a cell but at the content of a variable Ex: B = 13.34567
|
| Update numerous comboxes at once | 12 Apr 2008 18:04 GMT | 4 |
I can update the rowsource of an individual combobox programatically using the below; ComboBox2.RowSource = "details!g4:g24" however i need to do a lot at a time, looping through them one by one.
|
| Conditional Format / VLookup | 12 Apr 2008 17:40 GMT | 5 |
What I would like to do is have a conditional format which looks at the value of the cell then find the matching value on the WorkShifts Monday worksheet (that value would be found in column A and then when it finds that look at Column U. If the value in column U is "Large" I ...
|
| nse website query | 12 Apr 2008 17:17 GMT | 2 |
please see the following link http://www.nseindia.com/content/equities/eq_scriphistdata.htm the site generates historical data of price and volume based on various inputs as follows: scrip code, start date and end date. suppose we choose
|
| Autofill problem | 12 Apr 2008 17:09 GMT | 2 |
I've got a macro that will take the value in the previous cell and extend the series to the adjacent cells. Unfortunately, it isn't acting in quite the way I had planned. The number of cells to be filled is variable. For instance, a year will be entered into cell
|
| Hide menus etc in Excel 2007 | 12 Apr 2008 16:59 GMT | 5 |
How can I convert the following to hide the menus and ribbon in Excel 2007? ********** Dim Wksht As Worksheet
|
| Excel VBA macro to send email attachment from default email client | 12 Apr 2008 15:54 GMT | 2 |
I would need help to create a VBA macro that will send an email attachment (a .zip file which contains an encrypted Workbook) using the default email client (not necessarily Outlook). I would need to be able to specify the "To:" email address and the "Subject:". I don't need to ...
|