| Thread | Last Post | Replies |
|
| How do you Find with data in hidden columns | 11 Oct 2008 16:00 GMT | 5 |
In Excel 2003, I use VBA code to find the column with a specific title. The Find works well as long as the column is not hidden. Unfortunately it has to be hidden and I don't want to hard-code the column address. Suggestions welcomed!
|
| T^2 | 11 Oct 2008 15:56 GMT | 9 |
I'm trying to translate some Excel functions into an Access query but I'm very ignorant regarding Excel functions and hope someone can enlighten me! The person who created the particular Excel functions used "T". Two
|
| Function to return two values | 11 Oct 2008 08:09 GMT | 12 |
Is it possible to create a function that will return two values, a boolean and a string? I need to exit the main procedure if the data checked by the function is not valid and also display a message according to the particular validation.
|
| Selection.EntireRow - Filtered | 11 Oct 2008 05:24 GMT | 7 |
I am trying to copy (selected) filtered data from one sheet to another. Previously I have used Selection.EntireRow which copies a selection of filtered rows. I now need to just copy from Column C to Column AO - Not the EntireRow -
|
| Help with IF... Then... Else statement | 11 Oct 2008 05:17 GMT | 7 |
I originally was going to do this just as a standard (albeit long) function in Excel, but quickly had more nested levels then allowed. So my hope is that I can in VBA produce a custom function that will do all of the work and be compatible with 2003 xls format. Please let me ...
|
| Input box | 11 Oct 2008 04:40 GMT | 10 |
I'm looking for a way to have an input box popping up in a sheet I made. Basically, my sheet is a learning tool that gives me words in a language and ask me to translate them into another language. Now, say it asks me for "horsse" to be translated into French. I would to
|
| Format font of text in a message box | 11 Oct 2008 04:06 GMT | 4 |
I have a message box created, but can't seem to set the font or formatting of different parts of the text. eg. I want the message to read: Don't forget {in bold}
|