Skip to main content
216,486 questions
Newest Active Bountied Unanswered
-1 votes
0 answers
50 views

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 ...
MisterMonster314's user avatar
  • 1
3 votes
1 answer
122 views

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/...
Metal's user avatar
  • 45
1 vote
0 answers
76 views

I've been searching in the VBA documentation and couldn't find one regarding modifying/accessing the "seconds delay between letters" value when going through the animation effect settings ...
RedVersa's user avatar
  • 11
0 votes
0 answers
146 views

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
4 answers
150 views

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 ...
Collin Michels's user avatar
  • 21
1 vote
2 answers
178 views

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� ������������������...
Night_Guardian_0910's user avatar
  • 11
1 vote
1 answer
134 views

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 ...
BIPLAB GUPTA's user avatar
  • 11
-3 votes
0 answers
122 views

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 ...
testermitch's user avatar
  • 11
0 votes
0 answers
75 views

I try to implement something for Word. So I have plenty of letters I have to use for work. I want to make them easier and faster to work with. That's why I like to implement drop down menus with ...
Ann-Sophie Klaeßen's user avatar
  • 1
0 votes
0 answers
39 views

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 ...
Max's user avatar
  • 3
Advice
1 vote
15 replies
142 views

I have a huge table with over 2000 rows with text. Some rows begin with letters and rows that begin with numbers. I now need all the rows that begin with letters to cut and past them after the last ...
Roger20's user avatar
  • 21
0 votes
0 answers
53 views

I’m using VBA to refresh external queries in Excel that connect to Databricks via ODBC, since Power Automate cannot refresh external connections. The Excel files (50+) are stored in SharePoint and ...
srinrealyf's user avatar
  • 51
Best practices
1 vote
5 replies
210 views

I need to import the currency exchange rate table to Excel from the web (here's the link to the website https://vrbank.com.vn/ru/exchange-rate/) and update it on a daily basis. I've tried to use Power ...
Night_Guardian_0910's user avatar
  • 11
1 vote
0 answers
61 views

I have been writing a few scripts to help me with managing my inbox; one such script is to move all selected emails to a certain folder based on some criteria (not important). This works perfectly ...
Hany Elkady's user avatar
  • 41
1 vote
1 answer
92 views

I am trying to make a code that will allow a user to select a folder that is used in the same macro so anyone who places the workbook needed can simply select the folder where it is at to run the ...
Glenn 3JV's user avatar
  • 21

15 30 50 per page
1
2 3 4 5
…
14433