| Thread | Last Post | Replies |
|
| Combo Box - AfterUpdate | 25 May 2006 16:56 GMT | 4 |
Good day, I am attempting to develop a project for school with three Combo Boxes that will update upon user selection. Esstinally when I select the first combo box, I was looking to get the data assocated with that
|
| Cells(Rows.Count, "b").End(xlUp).Row | 25 May 2006 16:31 GMT | 1 |
So, you can use the formula in the subject line (Cells(Rows.Count, "b").End(xlUp).Row) to select the last cell in the column. But, I have a table with a variable number of rows, which will most likely be empty.
|
| Userform.Caption is blank when reference passed to class | 25 May 2006 16:25 GMT | 3 |
'** In MyClass.cls Private XLUForm As UserForm Public Property Set XLUserForm(vData As UserForm) Set XLUForm = vData
|
| Some VB coding required | 25 May 2006 15:59 GMT | 3 |
basically i want all rows on a worksheet hidden (except rows 1 & 2) default in a2 to be "april" (so it doesn't allow a blank) if cell a2 = "april" show rows 3:41
|
| How do I set up a greater than but less than formula in excel? | 25 May 2006 15:56 GMT | 2 |
I am tring to sort data to look at one of three tables. Once it finds the right table, then it produces a value based on the table. I can get the ones to work for <50000 and >100000, but I am having trouble establishing the criteria for the >499999 but >100000.
|
| Transpose | 25 May 2006 15:51 GMT | 2 |
I am not a programmer, but can anybody help me on this: I have data in one worksheet, in: C9-c13 C15-C19
|
| Formula Reproduction | 25 May 2006 15:35 GMT | 3 |
Okay, here's my formula, very simple: =D2/D51 Now that resulting value beigns in E2. When I try to drag the formula to do the same things in every following cell in Column E, it doesn't work. I want
|
| Workbook_Open macro question | 25 May 2006 15:35 GMT | 3 |
I'm trying to get a message box to pop up when my workbook is opened. I found this macro structure in a previous post: Private Sub Workbook_Open() MsgBox (" text ")
|
| how do I copy worksheets between workbooks without the macros? | 25 May 2006 15:28 GMT | 1 |
I'm using Excel 2003 and have a function that exports worksheet tabs from one workbook to another using the copy method. Turns out that it copies EVERYTHING - vba code, formatting, the whole nine yards. Since I want to keep the formatting (for display and print), is there a way ...
|
| Find and copy | 25 May 2006 15:01 GMT | 2 |
I have a list of data several thousand rows long. For each time that 123 occurs in column F I would like to copy the text from (same row) column A and paste it at the bottom of a list that starts in cell Z5. I currently do it with an Excel List filtered and then copy "Visible
|
| Running a .exe from VBA | 25 May 2006 14:54 GMT | 3 |
Hi All, Does anyone know if it is possible (and if so how?) to run a .exe fil from VBA in excel? Specifically, I would like to add a command butto to my worksheet and when it is pressed it runs a .exe file which is i
|
| Help, please | 25 May 2006 14:46 GMT | 7 |
Hi, I have a huge spreadsheet of baseball players....Some players played multiple positions during a single season. What I want to do is find the duplicate player ids for a given year and then find the position they played most for that year and delete the other records. For example
|
| No. of Columns | 25 May 2006 14:36 GMT | 1 |
This may not be the thread to ask this, but.... Quick question. Does anyone know if Excel 2003 has more columns than the 256 in older versions? I thought I read somewhere that it did. I Import a company database into Excel frequently and Excel won't let me do
|
| Opening MS Applications | 25 May 2006 14:18 GMT | 16 |
Is it possible to launch MS Office Outlook from Excel via a Macro? TIA
 Signature gti_jobert
|
| autosize | 25 May 2006 14:16 GMT | 2 |
I have a code that autosizes all my columns only when you, but it only works when you click another sheet in the work book and then click back to the sheet with the code. How do i get it to autosize when you move to the any other cell instead of having to go to another sheet and ...
|