24 questions from the last 7 days
Best practices
3
votes
12
replies
186
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
Tooling
1
vote
3
replies
92
views
Convert complex pdf to an excel
I'm currently searching for a solution to read a pdf and convert it to an excel.
For now I found the "tabula-py" library, which seems to be good. But I'm not quite sure because the pdf has ...
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
Advice
0
votes
8
replies
127
views
Excel conditional formatting: how to format entire RELATIVE columns based on single row value
My question is quite straightforward - or at least, it should be!
I have an Excel sheet with dates and weekdays laid out across the top three rows. I want to highlight all columns in a particular ...
- 1,516
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 ...
0
votes
1
answer
64
views
VBA Code to get a formula returned in column2 when column1 is not empty, error in my formula
I have the following VBA code, but one line is giving an error:
rng(i, 4).Formula = "=IF(LEFT(A" & (i + 1) & ",2)="RN","RN",IF(LEFT(A" & (i + 1) &...
0
votes
0
answers
72
views
Importing data: VBA run-time error 1004 Application-defined or object-defined error
I am trying to import a table from one workbook to another, but I want to add to the table with each import to the next empty cell (i.e. don't want to over-write existing data in the target workbook). ...
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
-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
-2
votes
0
answers
63
views
Is it possible to exit a nested ForEach Loop Used to propagate through excel worksheets? [closed]
I have a For Each Loop container which loops through files in a folder. Inside that container, there is another dynamic For Each Loop container that loops through the worksheets inside the file ...
- 17
-4
votes
0
answers
74
views
Prevent fill, drag and allow single/multiple delete in one sheet of a workbook [closed]
Option Explicit
Private oldAddress As String
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
' Prevent drag fill by breaking the selection extension
If ...
