288,864 questions
2
votes
1
answer
31
views
How to stack column arrays of variable rows returned by a user defined LAMBDA function using VSTACK? Is there an alternative?
First of all sorry for using Excel Android while asking questions.
My Goal:
From the text in B3 and B11, I want to create an array in which each element represents a line of the combined text ...
0
votes
1
answer
112
views
Autofill formulas using a macro
I am trying to have this macro auto fill the formula in T2 and U2 down. The issue is that the amount of rows will always be changing so the static ending at T70 and U70 does not work. Is there a way ...
Advice
0
votes
2
replies
63
views
Pulling Specific Data from Closed Workbooks
Firstly, thank you for your time.
I have a workbook that I put together for my supervisors. I am relatively new to the more in depth aspects of Excel. I am hoping I could possibly get some insight on ...
1
vote
2
answers
92
views
VBA Application.Match Object Required 424 Error
I am trying to write a callable function with a parameter that will return the column number. The column will be passed in via the parameter. As you will see I have the jobs variable which contains ...
- 13
2
votes
3
answers
86
views
How do I determine the state of a VBA workbook before attempting to close it (Excel 2007)?
I have found (by using the Watches window) that there are at least 3 different states that a workbook can have. Let's call the variable defined as workbook wb:
wb cannot be expanded and has the value ...
-1
votes
0
answers
147
views
Case-Sensitive Lookup for UDT Arrays
Background
I have developed a working prototype of sPrinter, which supports "printf" behavior in VBA and Excel.
vPrint "You have a meeting with {1} {2} at {3:h:MM AM/PM} on {4:dddd, ...
- 3,583
0
votes
1
answer
97
views
Making an Automatically Updating Table With Daily Updated Data From the Web (Excel Power Query)
Background: I work in wildland fire, and I'm trying to help out one of the fire officers who wants to track forecast fire indices and compare them with the observed indices over time. The system we ...
Advice
0
votes
5
replies
88
views
Searching to see if an item appears in multiple arrays
I am trying to use excel to check if a specific item appears in an array. I have figured out how to have it check against a single column, but when I set the array to be multiple columns I get a #...
- 1
2
votes
1
answer
109
views
Why does entering date via InputBox swap the day and month?
I'm trying to allow a user to input date into a cell using an InputBox. I'm using dd/M/yyyy format. However, every time InputBox receives a date that could swap the day and month, it does.
E.g. 3/2/...
- 33
Advice
0
votes
6
replies
137
views
Xlookup returning wrong information
I am creating a summary sheet where information is drawn from 3 worksheets (BM1, BM2 and BM3) and is formatted as follows
row no
col B (comp no)
col C (line no)
col D (t or b)
competition name/venue
...
Advice
0
votes
6
replies
93
views
Automate Downloading Reports (Excel Files) then Copy/Pasting Them to Google Sheets
I may be waaayyyyy out of my element here, but before I spend hours and hours researching and learning how to do this, wanted to ask people much smarter than me if this is even possible. :)
So! I ...
- 11
0
votes
2
answers
119
views
Sheets Found in Workbook But Code Stops Running
My code creates several formula checks, starting on a tab named NL20.
Dim ws As Worksheet
Set ws = wb.Worksheets("NL20")
'my code running here, creating formula checks
At ...
- 27
0
votes
1
answer
107
views
Range.Find Method not Working For Seemingly No Reason
I have a workbook with a lot of data columns. I am attempting to change it over to use assigned column variables instead of numbers, because the numbers make it a huge pain to add columns later if I ...
- 11
0
votes
1
answer
49
views
NUnit Testing with COM objects for VSTO Add-Ins: HRESULT: 0x80004002
I'm building an Add-In for Excel and I've been using NUnit to test. This is presenting a problem when it comes to testing functionality that interacts with Excel through the COM. I having problems ...
- 495
Advice
0
votes
2
replies
99
views
Flutter: Auto-populate Excel (DTR template) from SQLite data and preview before export
The app can now save the records. My only problem is I'm stock on how the app can use my existing template and automatically insert the data in each cell, while also adjusting the cell format if it's ...
user20814004