289,520 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
3
answers
105
views
Sum of total value for all dates separately in excel based on values from a table
I'm trying to get a report sheet based on another table that contains more data
i have succeeded in creating the date column based on the available dates in the other table using =UNIQUE(FILTER(...
0
votes
2
answers
82
views
Why is freeze panes causing error 1004 when workbook is minimized?
The following code is working in most cases perfectly.
However when WB "TestNew" is minimized the runtime error 1004 comes up on
Line with "FreezePanes".
Workbooks("...
-3
votes
0
answers
73
views
The clipboard contains a range object. How do set myObj = ClipboardRange in Vba under Excel 365. (application.calculate) [duplicate]
A fairly well known problem with Excel's Application.Calculate is that it ERASES the clipboard when it has range object. This has frustrated me in multiple projects for many years.
In fact, it is not ...
Advice
0
votes
3
replies
115
views
What-if analysis using Python or Excel
I have an important assignment that I have to complete for a new role that I am giving an interview for. And I am having trouble understanding last three questions in order to execute them. It is a ...
-2
votes
0
answers
64
views
Error message still appears with file lookup in sharepoint despite error handling - VBA Excel [duplicate]
My problem is very similar to this post: Excel error dialogue still pops up even with error handling but the answers did not seem very relevant and so I wanted to re-ask, but I will give more of my ...
1
vote
3
answers
134
views
Excel nested SCAN() formula by columns
I'm using the SCAN() function to build a column vector in which the result depends on the value of each row of the input vector and the prior row of the output vector. The value/accumulator nature of ...
4
votes
2
answers
171
views
Excel VBA file copy external to excel
I have a spreadsheet setup, where I loop through each row of the sheet, gathering a cell's data, combining it with a few other cells on other sheets to create a file path, and then copying the file/...
0
votes
1
answer
80
views
Excel formats and copies text instead of just formatting
I'm trying to format text when it is on equal to the text of an adjacent cell. I create a custom format that looks like this:
=$E2<>$F2
Excel does the formatting (just bolding) appropriately, ...
0
votes
0
answers
162
views
How can export cell where value is "Pictures" to a file?
I have an Excel, and one of the cell values is a "Picture" Object. It is not a shape.
How can export this picture to a file?
This is my code, but it can't copy picture to Chart.
Sub ...
mum's user avatar
- 1,645
1
vote
3
answers
183
views
How to calculate total of values based on if other variables are similar?
I'm trying to create a simple macro, and the solution is eluding me.
Let's say I have a table:
Header1
Header2
AAA
100
BBB
200
BBB
150
BBB
250
CCC
300
CCC
200
I want the formula to calculate so that ...
1
vote
2
answers
181
views
Can't access <tr> in <table> with VBA
I'm using VBA to import the table from Federal Fund Rates into Excel.
So far I've got:
Set HTMLDoc = CreateObject("HTMLFILE")
HTMLDoc.body.innerHTML = objHTTP.responseText�
������������������...
1
vote
1
answer
136
views
Copy paste multiple sheets data from a WB & paste in another WB in 1 Worksheet.Run TIme Error 1004 Application defined or object defined error
I am trying to copy data from multiple sheets of a workbook and paste it in a single worksheet of another workbook. But while running the code i am getting Run time error 1004. 'Application-defined ...
-3
votes
0
answers
125
views
Can't add row to bottom of table when another specific table is below it |VBA
UPDATE: Thanks everyone i managed to fix it by just temporality moving the table 2 out of the way and moving it back.
I'm making a small personal project and for some reason, when I add a certain ...
0
votes
0
answers
39
views
VBA Code to PivotFilter non zero values on Calculated field
Sub test2()
Dim pt As PivotTable
Dim pfRow As PivotField
Dim pfData As PivotField
Set pt = Sheet8.PivotTables("PivotTable1")
Set pfData = pt.PivotFields("Sum of ...
4
votes
2
answers
115
views
How can I concatenate values from a table and store the result in a new column?
I'd like to concatenate values from all columns of a table and store the concatenated result in a new column. Yet, as far as I can see, I can only run a single expression in an `each` function body.
...
AxD's user avatar
- 3,324