I would like to add a pause to the following macro so that it inserts the word CANCEL 1 second after triggering. I know I need to use the Application.Ontime function but cannot work out how to integrate it.
Code: Sub Cancel() Application.ScreenUpdating = False Sheets("Sheet1").Range("T5") = "CANCEL" Application.ScreenUpdating = True End Sub
I'm preparing Quarterly Evaluations, and am having an issue because an Analyst has superseded an overall percentage goal. In the attached example, it is the overall evaluation with the 'problem data' in red D19 and highlighted.
I'd like to add a condition that limits the points in D19 for 'responsibility 3' to 150.
*just a note for clarification, the other two responsibilities are a 'per hour' weekly goal, whereas the 3rd is an overall personal effort divided from the overall team effort.
I have a spreadsheet of over 8000 addresses. I have the street, state and zip but not the cities.
Is there a way I can do a search and mass import of cities from a website, like USPS? I'd like to know if there is something I can do quickly rather than manually look each zip code up and enter it in one by one.
In the attached workbook I have 3 sheets. The first 2 with the names starting with WO are individual sheets based on a single scaffold rental. The "Standing Equipment" worksheet is adding the components from the other two worksheets. Easy enough, but I am looking for either a formula or some VBA guidance on how to have the "Standing Equipment" worksheet automatically change it's formulas to incorporate new worksheets as they are either added or deleted, thus avoiding constant formula editing as scaffolds are erected or dismantled.
I'm verrry new to editing VBA code and I've been trying to figure out how to send a column of data ("Min Data" AB3:AB21 from "Sheet1") to a worksheet ("F4" - Min) and sending another column of data ("Max Data" AC3:AC21 from "Sheet1") to a different worksheet ("F4" - Max) by using only the one button ("Record Data" from "Sheet1"
I've been trying to figure out ways to edit the VBA in "Module 1" to make this work
Can anyone help me out here? If what i'm asking for isn't clear enough, just let me know and i'll try to explain in more detail.
In a workbook made in Excel 2003, I have the following for a UserForm:
Private Sub UserForm_Activate Me.Calendar1.Value = Date End Sub
I copied this workbook to a computer with Excel 2007 and it bombs out at "Date" It comes up with a compile error, "Can't find project or library"
In the references window (Tools, References) it has the "Missing: Ref Edit Control" checked and the location at the bottom of this window states "C:Program FilesMicrosoft OfficeOffice11REFEDIT.DLL".
The reference to Office11 is from the computer with Office 2003 as the computer with Office 2007 has Office12.
There is another "Ref Edit Control" in the References window and when I check it and browse to the Office12 folder, highlight REFEDIT.Dll and click on open and in the references window on OK it comes up with "Name conflicts with existing module, project or object library". I have tried to delete the "Missing: Ref Edit Control", change the priority and change the reference in the missing control to Office12 but all to no avail.
How can I change the reference to the Ref Edit Control from Office11 to Office12?
I have created a population pyramid and want to add another chart on the secondary axis which I can do. The part which I seem not to be able to complete is getting the line chart secondary axis to read from the primary y axis. It seems to add a new axis, even when I delete this the line chart does not read correctly.
Is it possible to add to an existing cell number with VBA rather than replacing the number? I would like to type a part# and a new qty in "Inv adj" sheet(A1 and B1) and have it find that part number in "names" sheet (A:A) then add the new qty to the existing qty in "names" sheet. (B:B)
A B 1| part-001...... 4 2| part-002...... 2 3| part-003...... 1
A B 1| Part-003...... 6 (running macro should then change "names" "B3" to qty "10")
I have this, but it only copy and pastes. not exactly sure how to get the cells to add....
Code: Sub adjustment() Sheets("INV ADJ").Activate Dim ran As Range
I need to add a decimal point to a column of numbers. For example, where it says 126 needs to be changed to 1.26, 3035 changed to 30.35, 13593 to 135.93 and so on. Can this be done automatically or with a formula?
I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS THAT ALREADY EXIST IN CELLS IN A COLUMN. SORT OF LIKE USING "FIND & REPLACE" EXCEPT THAT I DON'T HAVE ANYTHING TO REPLACE; I JUST WANT TO INSERT A LETTER PREFIX IN FRONT OF NUMBERS.
Just curios if this is the most efficient way to copy a workbook x number of times. I tried copying 77 workbooks and not sure exactly how long it took, but about 2 mintues. The original workbook is 300 KB.
I have a sheet that auto-populates with code from a userform that also provides the cell formatting. What I need is that in Column A it keeps a running count of the errors that are populated on the sheet.
Code for the formatting
With ActiveSheet lastrow = .Cells(.Rows.Count, "B").End(xlUp).Row
For i = 4 To lastrow
If Cells(i, "B").Value "" Then With .Cells(i, "A")
With .Offset(0, 0) .Value = "1" End With
.Offset(0, 1).Resize(1, 9).Borders.LineStyle = xlContinuous .Offset(0, 5).Resize(1, 3).Interior.ColorIndex = 35 End With End If Next i End With What I need is instead of Value of "1" with the offset(0, 0), I need it to take the previous rows value and Add 1.
So the Range("A4").Value = "1" Range("A5").Value = "2"
As the new errors are added to the sheet I need the value in "A" to be 1 more than the previous "A" value.
What's the fastest way to display the sum of each column in one row. Here's a picture of what I want to do: http://www.filefreak.com/ppublic/33833/excel%20help.bmp now I want the sum of each column to be displayed in for example row 10. I have tried manually clicking "autosum" (sp?) but that will take a lot of time as I have about 400 more of these.
I have a large spreadsheet of employee data saved in a shared network folder so that others can access it. Starting about a week ago, anytime I enter a number in any cell, Excel adds two zeros to the end of the number. For instance, a 1 becomes 100.
When other users open the file on their computer and enter a number, everything is normal - no zeros are added. I'm guessing I inadvertantly enabled a function somewhere along the line, but have been unable to figure out how to undo the function.