|
Excel/Cellphone Hi, I would like to know if it's possible to program Excel to send Text msg to Cell Phones. ... 7 Jun 2010 17:45
Sort Routine Macro for Excel Worksheet I have an excel that requires a sort routine. I tried using the start/stop recording. The code is shown below, however, I need this routine to work when you don't know how many rows are in the data. My method has the filename hardcoded too. I don't know if that matters. This one subroutine of many. Can so... 7 Jun 2010 17:45
Floating text Hi everyone, I'd like to have some question+answer showing up on top of all my applications() to make me read it and memorize it. I know that I can hide Excel, but how can I hide the form but the text on the form to be visible? There is anyway to do it in VBA? ... 7 Jun 2010 17:45
Deleting Duplicate Rows Hi, I checked out the archives for close to an hour, but I couldn't figure out how to change the codes given there to suit my needs. I have a large set of data, from about A1 to X441. In column X, there are a lot of exact duplicates, and I need to delete the rows where those duplicates are (but still leaving t... 7 Jun 2010 18:52
Macro if criteria Hi, i have two macros. (macro 1 and macro 2) I need macro 1 to run if in A1 is "JOHN", in B1 is "MARY" and if C1 is empty ; and macro 2 to run if in A1 is "JIM", in B1 is "CRIS" and in C1 is "BOB". Can this be done? Thanks! ... 7 Jun 2010 17:45
External Data from SQL Server I have a worksheet that is importing data from SQL Server. MS Query is configured to execute a stored procedure. Sometimes when I refresh the query with new parameters I lose formatting and formulas. It is as if Excel is inserting extra columns. the cells with the formulas are moved to the right and lose th... 7 Jun 2010 16:38
Code not working in a PROTECTED Worksheet I have the code below in a worksheet on a file in SharePoint. The worksheet is Protected so only unprotected Cells are selectable. The problem I am having is that when the sheet is protected I get an error on: Me.Rows("5:169").EntireRow.Hidden = False and I know it is because on the protection because wh... 7 Jun 2010 16:38
VBA Code to select and format range Hi All, I want to select a range of cells and format the range of cells based on a "offset" feature... The last couple lines in my code are: ActiveCell.Offset(1, 0).Select ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)" Where the active cell reference is a moving target depending on the amount o... 7 Jun 2010 17:45
Save data before printing Hello all, An acquiantence is programming in Excel 2003 and has a sheet where theuser enters receipt data. When he is done, he clicks a boton to copythe data from the sheet to another in tabular form withinthe same workbook. What he needs to do is to implement a lock so that the user can't print out the receipt ... 7 Jun 2010 17:45
Can use VSTO to reduce the size of a file? I have a really large spreadsheet that is saved in a sharepoint location but takes about five minutes to load. Would it make any difference if I recreate the file using VSTO? Thanks in advance ... 7 Jun 2010 14:20
Change event does not fire Hello! I have a worksheet with checkboxes. Each checkbox is linked to a cell. When checkboxes are checked/unchecked the cell changes, but the Change event for the sheet does NOT fire! Is that how it is supposed to be??? I wanted to use this method instead of Checkbox Click event, because I have lots of checkbo... 7 Jun 2010 17:45
When this NG migrates to forums, please consider ... Many of the questions in this NG fit into the following template: My [boss/teacher] gave me this problem that would be really easy to solve if I had a clue about VBA programming but I don't. Would someone please send me a solution? This makes it difficult for people working at a higher level to cope with t... 7 Jun 2010 14:20
Trouble with dynamic named range In an Excel 2010 workbook I created a dynamic named range from the Formula tab using the Define Name utility. The formula I entered is: =OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP:$AP)-1,1) I want the range to include all non-empty cells in the AP column starting with the second row. When I check... 7 Jun 2010 18:52
Drop Down with hidden values I need some assistance please. I have a spread sheet that I have drop down information on. When the user selects the word from the drop down list, I would like for the word to have a numerical value to it that the user does not see, but accumulates at the end of the column. Such as: Hamburger = 25 hotdog = 1... 7 Jun 2010 15:30
Worksheet Cell Reference I have a reference to a cell in another worksheet, same workbook. When the value in the referenced cell is blank it returns a "0" value. However, I want the returned value to simply leave as a blank cell. Any advice? David ... 7 Jun 2010 14:20
Solver Hi Group, I am having a hard time programming Solver. This is the code I have so far: Sub SolveNew() Worksheets(ActiveSheet.Name).Activate SolverReset SolverOptions precision:=0.001 SolverOk SetCell:="$C$48", MaxMinVal:=3, ValueOf:="100000", ByChange:= _ "$C$32,$C$34,$C$36,$C$38,$C$40,$C$42,$C$44... 7 Jun 2010 14:20
Need largest number I have a file in Excel 2003. In 1 column I have a numeric field. In the next column I have a 2 digit apha field. In the third column I have another numeric field. For each row I need a formula in the 4th column. All columns can have duplicate numbers/characters. What I need to do is find the largest numbe... 7 Jun 2010 18:52
Multipage, controls-collection and events (XL2003, VBA) Dear Group, I have a Userform with a Multipage control, which is dynamically filled with textboxes and comboboxes using Controls.Add like this: Set aTextBox = aUserForm.aMultiPage.Pages(strCurrentRegister).Controls.Add("Forms.TextBox.1", "txt" & strText, True) Set aComboBox = aUserForm.aMultiPage.Pages(s... 7 Jun 2010 13:02 |