24 questions from the last 7 days
Best practices
3
votes
12
replies
185
views
SpellNumber Simplified Using LAMBDA() function
Here is the custom function to spell number to words using LAMBDA(). I would appreciate any improvement of the function or simplification if possible. Also suggest best practice for the function.
=...
- 38k
2
votes
3
answers
145
views
Excel VBA Code doesn't insert and Paste Values to a protected sheet
Sub ShopeEntry()
Sheets("Entry").Select
Range("D5").Select
If IsEmpty(Selection.Value) = False Then
Sheets("Entry").Select
Dim ...
- 39
-1
votes
0
answers
126
views
VBA to send email to a range of addresses, changing subject and body [closed]
I am looking to create a macro that will email a range of addresses as per the following criteria:
Column A contains email subject
Column B contains email addresses
Column C contains email body
...
- 1
Best practices
0
votes
4
replies
100
views
Best way to extract a VBA Date out of a byte array and turn it back into a valid VBA Date?
I have confirmed that the following VBA code works just fine.
Dim mydate As Date
mydate = Date
Open "C:\Windows\Temp\dlctest.data" For Binary Access Write As #1
Put #1, , mydate
Close #1
...
- 153
1
vote
1
answer
89
views
Pandas converts Excel strings like ‘2004E205’ to scientific notation — how to prevent this
How can I handle string values that contain patterns like xxxE205 (e.g., 2004E205), which are used as unique codes in my company? I explicitly read the column as a string in pandas, but values ...
- 11
1
vote
2
answers
76
views
How to check if two cells in the same column contain matching text in Excel?
Is there an Excel formula that can detect whether two cells in the same column contain similar or partially matching text?
For example:
F3 contains: "regulation BI, how to stop exploitation"...
0
votes
0
answers
101
views
Why am I getting an Out of Memory error with this specific VBA code?
Hi I am relatively new to coding VBA and I am getting an out of memory error that I wasn't previously getting in the 8ish months I have been using this code. I hope someone can help me diagnose how to ...
3
votes
1
answer
67
views
Trying to populate a list from another sheet by a single reference number
I am working on a handy reference sheet for my DnD Games, that includes 10 pre-planned encounters of varying difficulty that I want to reference on an Initiative Sheet by referencing the Encounter ...
0
votes
1
answer
90
views
Excel INDEX MATCH with single row and multiple columns reference
I need to find openings in a group of people's schedules because I can't merge them easily with any native web program we use the calendars in. I will be looking at each person's calendar at a time ...
-3
votes
0
answers
36
views
MS Excel Web Add-in - Rollout via MS 365 Admin Center
We have developed a ReactJS based Excel Web Add-in, which we are rolling out using the Microsoft 365 Admin Center. The steps that have worked for our Admin Center, as per our IT department (Office 365 ...
- 107
0
votes
0
answers
51
views
I need to stop a tab from being exported. Is there a Workbook BeforeExport similar to BeforePrint?
I have managed to stop a tab from being printed using the BeforePrint... I now need to prevent the File|Export from firing for the same tab. Is there something like the code below to stop FILE | ...
0
votes
0
answers
18
views
Aspose.Cells (.NET) (25.5.0): Error Logging
I was wondering is there a way to configure error logging for Aspose.Cells (.NET). The version I am using is, 25.5.0.
I am facing one issue with an excel workbook that has more than 10 excel sheets ...
- 1