questions/page/68
You may learn whether it runs on ...READ MORE
Looks like the Worksheet_Change() sub needs two ...READ MORE
To fix the issue of null temperature ...READ MORE
For Excel 2019 and above use TEXTJOIN ...READ MORE
Hi@akhtar, You can give access to your user ...READ MORE
You can change the formula in the ...READ MORE
Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE
I need to use Excel formulas for ...READ MORE
Use SUMPRODUCT and double unay operators: =SUMPRODUCT(- ...READ MORE
You can accomplish your goals in one ...READ MORE
Try this: Sub UniqueList() Dim ...READ MORE
Use InStr function to find the beginning of the ...READ MORE
Solve By Calling with Module Name Another solution to the TypeError: 'module' object ...READ MORE
Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE
Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE
Try this: Sub BorderArroudAreas() Dim sh ...READ MORE
To store your public objects and expose ...READ MORE
It is not working because your code ...READ MORE
You will need to save the attachment ...READ MORE
Try this: Sub Test() Dim ...READ MORE
Use match() and if() without code at ...READ MORE
Make sure you're setting Response.StatusCode to something other than ...READ MORE
The xlsx extensions are not supported by ...READ MORE
Replace Occurrences of a Substring With a ...READ MORE
Ctrl-shift-home goes to the upper-left of all ...READ MORE
Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE
Try this: 'put this sub in ThisWorkbook module ...READ MORE
The delta column in PowerQuery is calculated ...READ MORE
I think this might be more of ...READ MORE
Try the following: The formula in F1 (as per my ...READ MORE
To make the image in your Flutter ...READ MORE
Qualify the sheets with a workbook reference ...READ MORE
Verify that it is actually in your ...READ MORE
This will print every thing from row ...READ MORE
Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE
If you have duplicates and want to ...READ MORE
Pivot Tables are mainly designed to create aggregated data from ...READ MORE
If you are saying Basic authentication, then ...READ MORE
If you're using a previous version of ...READ MORE
Use the openpyxl module in Python to do that, ...READ MORE
Use just datetime.fromisoformat(row['Date']) but I didn't have ...READ MORE
When a value is made up entirely ...READ MORE
The original macro was created in an ...READ MORE
Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE
The SQL server supports many formats. Most ...READ MORE
Hi@akhtar, I think there is a problem with ...READ MORE
This 201904 is recognised as a number ...READ MORE
It appears that when a UserForm is ...READ MORE
Try this: let columnNames= {"E ...READ MORE
It is simple to compare once you ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.