run-time

Hello,The following code generates a Run-time error (13) Type mismatch: Dim IloscWierszy As Long IloscWierszy = Application.VLookup(.Cells(i, 2).Value, _ "'[" & PlikBudżet.Name & "]" & PlikBudżet_arkusz.Name & "'!R" & WierszKosztyPensji_Budzet + 2 _ & "C" & OstKol_Budzet & ":R" &...

Folks! My .xls file is stored on a Confluence page. When I download it, I have to press the activate editing button - which results in an error message: The code that fails is: Value_ = Sheets(workingsheet).Cells(param2, param1).Value() I substituted the variable names with the real values...

Hi, I have a fresh installed Office 2007. When I open Excel, a pop up comes up saying there is an error: Run-time error '91' How do I remove it? Have reinstalled Office 2007 multiple times. Even installed Office 2003 n yet same problem. OS: Win 7 Pro

I have one data source sheet and 3 pivot tables that I want to all update automatically. I am getting this run-time error 1004 when I try to input a new row or make any changes. Below is the code I have for all 3 pivot tables. Can someone help me please? Run-time error 1004 Unable to get the...

I have all of a sudden getting the error:Run-time error '-2147319779 (8002801d)': Method 'MailEnvelope' of object'_Worksheet' failed when I run the following code: Range("A1:E100").Select ActiveWorkbook.EnvelopeVisible = True ' Show the envelope on the ActiveWorkbook. With...

Hello All, I have a problem with a macro below as it returns Run-time error '1004': Method 'Range' of object '_Global failed. I have identical macro where if cell.value 2,3,4,5 etc. works perfectly but not the one below. Worksheet is not locked and scroll area is not limited in any way as...

The code where the error code occurs is as follows: 'Calculate Production function Output_t1 = GrowthFactor ^ (Period_Length) * (Output_t0 + FactorProductivity * (1 - Damages_Production_t1) * _ (1 - AbatementCost_Production) * (CapitalStock_t1 - CapitalStock_t0) ^...

I'm hoping to get this working. My Excel project has a number of forms each of which can be opened from a number of buttons at the top of each form (i.e. a navigation bar - clicking a button opens the target form and closes the current form). At present each form has code similar to that below...

Hi, this is my first time posting, so hopefully I do not mess it up too much. I am currently using Excel 2013 to create user input forms for recording information about support calls. I am relatively new to VBA and am pretty stumped on the Run-time error I keep receiving. I have been using the...

I have a pivot table with 2 Row Label ([RAMI PN] & [U of M]), 1 Column Label [Date], and one Sum of Value [Weekly Inventory]. I had a slicer set up that would allow the user to filter by [RAMI PN], but 2 of the frequent users have Excel 2007, which doesn't allow slicers. As an alternative...

I am teaching myself VB using ms Excel 2010. I am trying to search through 7000+ rows of data for certain keywords, and then pasting these rows to another sheet. I have the code to where it works when I step through line by line with F8, but when I actually run the code I get "Run-time error...

Hi Folks, This is going to be a lo-o-ng post, so thanks in advance to those who power through it and reply to this thread. I have a mature (been in use for 3 years) spreadsheet that was created w/ Excel 2007 and saved as an *.xls file as most end users still run Excel 2003. This...

I'm using the following in a macro and it seems that none of the criteria match, so while running the macro it gives me a run-Time error '1004'. "Unable to get the AverageIfs property of the WorksheetFunction class". How to handle this? I need to treat the average as a zero when the criteria...

Hi, I've written a macro which has been working perfectly for all but one user. The original spreadsheets have been in place for around a year however the Macro is new and the final users spreadsheet is new as well. Whenever i try and run the below for this user only and on any PC i get a...

I have a userform with 2 tabs - on the 2nd tab there are two fields that contain dates (using the Windows Date and Time Picker Control). I get this error when the first tab is selected and my userform updates with the data in my spreadsheet. It works just fine if the second tab is the tab on...