I currently have the following:
I = quantity
J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future
J = add any number entered from the...
The code below is acting as expected...
If user enters "Personal" in any cell in Column J, cells on the same row in Columns K & L auto-fill with "Personal"
If user enters either "Misc." or "Other Meals" in Column K, cells on the same row in column L auto-fill with the same word
Hello - I hoping someone can help me with this.
I created a macro using the Macro Recorder to sort a column on my spreadsheet by a custom list.
STAGE 1 - PI
STAGE 2 - RD
STAGE 3 - W
STAGE 4 - LV
STAGE 5 - LD
I installed Excel 2013 on my PC. and made the excel workbook with VBA in it. It is now perfectly running.
When I went for work and used my newly made excel workbook. it started having many problems in our office we use Excel Office 365.
the Error I am having is...
I have been working on this VBA code but I keep getting the error '-2147024809(80070057)' The specified value is out of range.
Not sure why.
I'm trying to copy values from the excel sheet to a powerpoint presentation for an awards ceremony.
Any help would be appreciated. I'm using excel and...
I am having trouble with the below code. For some reason it will give a run-time error sometimes, but it is completely random. Unfortunately I can't provide the URL since it is internal but I'm thinking this error is due to a timing issue. As you can see below was my attempt at fixing...
I'm having some VBA problems. I've used the below code many times before on other workbook (just changing the specific parameters for each sheet)without any problem. However now I'm begging the "Run-time error '1004' Application-defined or object-defined error" error for the "East Mezz Input"...
I've been through this forum front and back and taking the suggestions from previous posts about this error has given me a lot of knowledge concerning this error, but the error persists nonetheless. Does someone see something I can be doing differently to stop this error from occurring?
MR. Excel Help
I am having trouble with a delete row macro for one of my tables in excel.
When I run my "Call_Delete_Row" code in an existing table after I open my excel spreadsheet, the last row for two tables on two different sheets are deleted.
However, AFTER I run...
Hi guys, so i keep getting an error saying "Object variable or with block variable not set"
the code used to work perfectly before i added something
what i added was
Set rng = Range(Range("A1"), Range("A1").SpecialCells(xlLastCell))
Set tbl = ActiveSheet.ListObjects.Add(xlSrcRange, rng...
I have code in a program that clears all data from all forms on all sheets.
As part of this program I execute the following code to delete all existing charts:
Dim wsItem As Worksheet
Dim chtObj As ChartObject
For Each wsItem In ThisWorkbook.Worksheets
For Each chtObj In...
I try to run an Access macro from an Excel macro.
I've found some helping tips, but it still doesn't work.
The relating part:
Dim appAccess As Object
Set appAccess = CreateObject("Access.Application")
appAccess.opencurrentdatabase "G:\Risk Management\Common For Risk...
I wonder if anyone might be able to help me?
I've come across an error in a workbook set up for the 2016 year (it was a direct copy of the 2015 original, clearing previous data and updating the date range).
When I run the macro in the 2016 file, I am presented with the following error...
Hi fellow VBA practitioners,
Today I have a challenging (maybe not?) exercise for those of you who know VBA. The case I'm about to describe is pretty simple, however completely kills all my weekend (second one to be precise).
I managed to find & modify to suit my case the macro that would...
I'm new to creating user forms in excel so dealing with run-time errors is a little out of my wheel house. My user form has been working fine for over a year and then someone else edited my document and added a page to the multi-page user form. Since then this run-time error '2147417848...
I am trying to run the following in Excel 2013, but it won't work, I get run-time error "2147188160 Shapes.Paste: Invalid Request" and it is the blue line below which appearently is creating the problem. The macro worked perfectly in Excel 2010. However, now that I have had the file open in...
i keep getting the above error when trying to run this last bit of my code:
Dim laddercount As Double
Dim x, y As Double
laddercount = Evaluate("COUNTA(R:R)-1")
For y = 19 To laddercount + 19
For x = 7 To x + laddercount
I would like to use a macro script to import a (TAB separated) CSV file which was exported from a database. It seems to work - I can see that rows are being imported (although the first cell contains two additional weird characters: ÿþCampaign Name). However the script stops at "Line...
I made a userform via ActiveX Controls on my sheet, and I have a list box that uses Vlookup to fill in two other text boxes on my userform. Therefore, when the user clicks the part number from the listbox, the Part description ( TextBox1 ) and Std. Hours (TextBox2) for the part is filled...
I am getting this error on a workbook connections refresh that is done in VBA. I am using Excel Professional Plus 2010 and Windows 7. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code. The module with the error modifies a connection to an Access...