Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

Sorry - this might be a very old issue but so far I haven't found an actual answer. I want to communicate with Arduino Nano Every board's (virtual?) COM port. The C++ code on the Arduino seems to ...
0 votes
2 answers
75 views

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("...
-2 votes
0 answers
66 views

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 ...
-2 votes
0 answers
63 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 ...
4 votes
2 answers
163 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
  • 55
1 vote
0 answers
79 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
0 votes
0 answers
160 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
3 answers
182 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 ...
1 vote
2 answers
181 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� ������������������...
1 vote
1 answer
136 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
-3 votes
0 answers
123 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
0 votes
0 answers
76 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 ...
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
145 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 ...

15 30 50 per page
1
2 3 4 5
...
14432

AltStyle によって変換されたページ (->オリジナル) /