| Thread | Last Post | Replies |
|
| SharePoint Versions | 21 May 2008 20:12 GMT | 1 |
Can someone tell me if there's a way I can access versions of files in a SharePoint Document library?
|
| Dependent Validation List | 21 May 2008 19:38 GMT | 2 |
A worksheet contains data as follows: Column A ColumnnB Country1 $B$24:$B$30 Country2 $B$9:$B$18
|
| Delete last sheet in workbook | 21 May 2008 19:37 GMT | 13 |
First, thank you for looking at this post. I have a macro that takes the cell comments from other sheets and creates a summary sheet showing all of them. I'm constantly adding to the main sheets and running this macro but every time I do I have to first delete the sheet
|
| VALIDATION FUNCTION HELP | 21 May 2008 19:27 GMT | 1 |
How can I use validation to stop users from entering the following characters?: / \ : * ? " < > |
|
| vba - Select Used Range minus the top header | 21 May 2008 19:19 GMT | 4 |
I am using "ActiveSheet.UsedRange.Select" to select the used range and that's great. However, I can't figure out how to ignore the first row of data, because it's a header. I'm still searching the boards but I haven't seen anyone ask this question.
|
| Conditional Formating | 21 May 2008 19:16 GMT | 1 |
how can I have a cell change color if a cell within a group has the value of "1" and then revert back it the value changes. A3 (Cell to change color) B1:E10 need to see if any cell returnes "1" if so need to change A3 to a color
|
| sort entire range with exception of last row | 21 May 2008 19:15 GMT | 2 |
is there a snipet of vba code that could be used to sort 3 columns of variable length with the exception of the last row (last row used for totals). The column range is a:k (rows, again, are variable). I am looking to sort in this order:
|
| import multiple CSV files into one Excel file | 21 May 2008 18:33 GMT | 3 |
I have roughly around 2000 CSV files (each file is in the range of 49bytes-3MB, a total of 35MB). I would like to import each CSV file to an individual sheet in Excel workbook using Perl OLE.
|
| Get templates files and copy data to it | 21 May 2008 18:32 GMT | 22 |
I have a working sheet contains 15 columns and undetermine rows of data. I have workbooks saved as group name, eg. "ABC Ltd" in a folder named under group, eg. "ABC Ltd". These workbooks consist of about 5 -10 sheet templates and are named under "group person "eg. "ABC John"
|
| with a macro open a workbook without the Auto_Open running | 21 May 2008 18:29 GMT | 3 |
I wish to open a workbook that has Auto_Open installed. I merely want to extract information from a specific cell. My proglem is that the workbook when opend will run Auto Open. Is there a way to prevent the Auto_Open macro from execuiting?
|
| 2nd TRY: Up from 2003 to 2007; code now throws error creating object?? | 21 May 2008 18:24 GMT | 4 |
I've been beating on this for two days. I posted earlier in excel.programming (http://groups.google.com/group/ microsoft.public.excel.programming/browse_thread/thread/ fb2e4df1284c42a2?hl=en#), but I've gotten more info since then and
|
| copy row based on match and multiple criteria | 21 May 2008 18:22 GMT | 1 |
I need a formula or function that would look at a value in a cell, compare it to a whole column on another sheet If a match exists then I need the code to look say 10 columns further along in the same row at the cell value.
|
| Processing a Message Box w/in a Macro | 21 May 2008 18:17 GMT | 1 |
I could use help with the following; I have a macro and when I run it, it displays a message box offering three choices, "OK, Cancel and Help". When I choose "OK", the macro continues to run to a successful conclusion. I want to process this
|
| CLEAR FIELD TEXT ON CLICK? | 21 May 2008 17:54 GMT | 3 |
Hi. I have a form that I'd like to automatically clear when it's clicked for text input. Is this possible in excel?
|
| Goto ("A1") in non active sheet | 21 May 2008 17:53 GMT | 3 |
Hello all, i have a number of sheets that i am putting data in, but each sheet is not active when i do that. The sheet name is variable "s", is it possible to select "A1" on these sheets without activating them ? I have tried
|