Last seen: May 22, 2025
You could do something like this (it could probably do with a bit of refactoring and some error handling, but should get you started): Option Expli...
"I'm not sure saying 'rethink your approach coz using formatting to calculate is bad' is helpful. And "you really shouldnt be calculating anything on ...
For the difference, you could also use: =MAX(0,B2-C2)
Instead of hardcoding them in the code, refer to ranges like this: startDate = sheets("sheet name").range("A1").value for example.
That looks like OpenOffice to me, in which case try changing the comma to a semicolon: =C11*($D$9+ISNUMBER(FIND("PGS";B11))*1.5%)
How are you opening the new instance? If you do it in code using automation (I.e. not Shell) then no startup files are loaded (that has always been th...
Apologies - that's the legacy method. You would actually want (now that I'm at my computer) Data - New Query - From Database - From SQL Server Databas...
Your colleague should be choosing Data - From other sources - from SQL server database (the first option).
No worries - I confess my eyes tend to glaze over if I see MMULT in a formula. 😉
Just to note: cross posted in a couple of places:
Something like this?
Are there any hidden sheets in the workbook?
Try something like this: Sub SendemailAll() Dim xOutlookObj As Object Dim xEmailObj As Object Dim tempFile As String Dim strbodymsg As String ...
The entries in your Type column have a trailing space, so you need "Single Family " as the criterion, or use TRIM on the range.
The first 13 options for AGGREGATE require a range to process and will not work with an array, which is what your IF function is returning.