This is my first post here, so sorry if I made any mistakes (this forum has helped me a lot before tho, thanks!).
I'm trying to make a macro that will delete everything within a range of cells, but I'm running into a weird issue.
There's a couple of checkboxes and a picture that don't get...
Please help with this new error that all of a sudden occurs in a spreadsheet that I have been using for 5 years now.
The spreadsheet works well on 3 other PCs.
All of the PCs are running on the latest update of win10 x64.
The relevant part of the VBA code reads:
‘ Klaar Macro...
I have the following piece of code running when opening a workbook.
I want this workbook to be shared, but when I open in shared mode this piece of code gives me a run-time error '1004': Application-defined or object-defined error.
Works fine when not in shared mode. I have googled...
I am trying to run the following code one after another for three different ranges.
The macro extracts the ranges and save them as pictures.
Sub ExportBRRangeToPNG() '--exports selected range to png file
' jpg is not appropriate format for this output
' default filename is...
I have 2 VBA codes that are almost identical to each other, the only difference is that one of them has a prompt for message box with input to fill in column B. Basically code 2 is identical to code 1, but with all the columns shifted one down (B-C, C-D, etc). Below is code 1
Can't quite see/figure out what I've done wrong (I don't know what I don't know :confused: ).
Run-time error '1004'
Method 'Range' of object '_Global' failed
I've tracked the error down (I think) to the FOR-NEXT loops in the following snippet of code (edited for...
I have recorded a macro and now it is giving me a runtime error 1004 "There's a problem with this formula" in connection with ExecuteExcel4Macro.
I have tried with double quotes without success ExecuteExcel4Macro "(2,1,"""";;;@"""")"
Can anyone point to an error in the code?
Hi Excel folks,
I m trying to move every second row at the end of previous row.
This below code is being applied from the third row. I m getting the desired out , but i m also getting the below error.
" run-time error 1004 : Application-defined or object-defined error".
I m aware that...
I have vba that purges data for public posting, then saves each tab (named range) as a separate pdf to combine & post to the web. I'm getting a Run-time error '1004' "This formula is missing a range or a defined name" on Named Range(Table_7), on Tab "Table 7", when trying to save...
I have 50 named ranges. Some of them are just a range, others have dynamic ranges (formulas). None appear to be incorrect. Everything is calculating correctly based off of the named ranges. I have used the Name Manager to filter for Names with Errors and there are none listed.
I need to...
I am getting belowerror while converting XML file to excel.
I have 2 files in a folder I am able to convert the firstfile were as 2nd file shows the below error.
The xml file cannot be opened because of error...
I want to create a name for the data range of a given table column, using the syntax "Table[Column_name]", so that if the table moves, expands, shrinks, is renamed, or reorder columns (...), the range referred to by the name is still correct (per opposition to use the range address syntax...
I am sure this problem has come up before, but as a tyro I just don't know where my code is going wrong. I an trying to set up a macro, which will copy some data from a summary sheet into another sheet in the same workbook. Here is the code which is giving me angst:
' Add the new sheet...
I'm copying (Ctl-C) tabular data from a website and wanting to Paste it into my spreadsheet. When I manually select the destination cell and type Ctl-V it works just fine. However, when I try Pasting it via VBA I'm getting the Run-time error 1004 (PasteSpecial method of Range class failed).
I keep getting the following error and I don't know why:
Runtime Error '1004':
Method range of object global Failed
Here is my code with the line causing the issue denoted with the *.
Sub Button1_Click()ActiveSheet.Range("AL2:AL399").Value = 0
ActiveSheet.Range("BH2:BP399").Value = ""...
I am trying to create an automated script to automatically change multiple examples of the same field dropped into a pivot table into defined calculations of that field. eg change the first instance into average, second into stdev, 3rd into count etc.
This requires them to be renamed to...
I get run time error 1004 when I run the following code, which should synchronize the slicer caches:
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)Dim sc1 As SlicerCache
Dim sc2 As SlicerCache
Dim si1 As SlicerItem
Set sc1 = ThisWorkbook.SlicerCaches("Slicer_SolName")...
I'm running into a strange problem, for many years I have used these excel macros and all of a sudden I started to receive errors that only appear on one computer. This macro and pivot issue doesn't exist on any other computer I have tried. So excel was uninstalled and a fresh clean updated...
I have the below code that is working for most of my users but is crashing in the red line for some of the users. The only common trend I've found for those that this is not working is that they are Excel 2013 users as everyone else is Excel 2010. The Excel 2013 users have a run-time error...
Hi guys, I try to filter data that I have in Macro file in DataSheet ('DS'). I need to take filtered data only (w/o header row) & copy it into different workbook/sheet 'SFDCReport', where there is a Table (Header row on line 12, 1 data row on 13).
With this code, I received some Error 1004 -...