Trending questions in Others

0 votes
1 answer

VBA - Msgbox inside a Loop

 Try this: Private Sub CommandButton1_Click() ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
802 views
0 votes
1 answer

How to merge the Two Columns with two different Tables without getting duplicates in either of the resulting columns

Assume your tables as named are read ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
800 views
0 votes
1 answer

Change sheet tab color depending on CountA function result

Try using the ws. prefix to set ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,000 points
403 views
0 votes
1 answer

VBA - Build a Two-Column Array By Looping Through one Array with a Specific Criteria and Selecting From Another Array

As already mentioned as comment: Loop over ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
• 38,000 points
573 views
0 votes
1 answer

Count number of equal values in two rows in Excel

 Use this formula: =SUM(--(A2:E2=$A$1:$E$1)) READ MORE

Mar 21, 2023 in Others by Kithuzzz
• 38,000 points
701 views
0 votes
1 answer

VBA SharePoint macro

I believe you are attempting to open ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,000 points
2,207 views
0 votes
1 answer

VBA Excel get data from Access database Error

Try this: Sub getdata() Const ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
779 views
0 votes
1 answer

Issues with NULL in an added and custom column

Try this: Fonte = ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
• 38,000 points
559 views
0 votes
1 answer

VBA to create a dynamic rolling list of names

If I understand you correctly, a case. ...READ MORE

Mar 23, 2023 in Others by narikkadan
• 63,600 points
597 views
0 votes
1 answer

Excel, unable to update count

Try this: • Formula used in cell J14 =COUNTIFS($F:$F,$I14,$H:$H,K$13) Fill Down ...READ MORE

Mar 23, 2023 in Others by narikkadan
• 63,600 points
589 views
0 votes
1 answer

Encrypting and securing sheets for users

First off, instead of using a formula ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
• 38,000 points
670 views
0 votes
1 answer

Excel VBA code not running using F5 only F8

Change your code like this: Dim LastColumn As ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
• 38,000 points
662 views
0 votes
1 answer

Close One Tab within Chrome via VBA

Sod's law worked it out within a ...READ MORE

Feb 10, 2023 in Others by narikkadan
• 63,600 points
2,334 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Add column, custom column with formula: = try ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,600 points
2,613 views
0 votes
0 answers

Laravel Minio Temporary URL

I'm looking for a hacky way to ...READ MORE

Feb 14, 2023 in Others by Ashwini
• 5,430 points
1,381 views
0 votes
1 answer

Use union with find

Using the Find Method With a Discontinued ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
695 views
0 votes
1 answer

Merging duplicate cells into a new column with VBA

The requirement to pull the first Open ...READ MORE

Mar 23, 2023 in Others by narikkadan
• 63,600 points
516 views
0 votes
1 answer

Comparison operator with duration that may exceed 1 day with format h:mm

Try this: =IF(OR(AND(S2<=0.0417,D2="Imagerie Conventionnelle"), ...READ MORE

Mar 25, 2023 in Others by narikkadan
• 63,600 points
427 views
0 votes
1 answer

Why does WinHTTPRequest responseText return a different value to MsgBox than Debug.Print dynamic web pages

The Immediate pane has a built-in limit ...READ MORE

Mar 18, 2023 in Others by narikkadan
• 63,600 points
1,130 views
0 votes
0 answers

Excel Formulas Limitations when compared to Excel VBA Power

I'm an Excel VBA programmer that had ...READ MORE

Mar 26, 2023 in Others by narikkadan
• 63,600 points
409 views
0 votes
1 answer

My VBA Addin creates a custom ribbon tab, but should only be visible for intended workbooks

The RibRefresh sub's logic is overly convoluted ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,705 views
0 votes
1 answer

IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE

Mar 20, 2023 in Others by narikkadan
• 63,600 points
619 views
0 votes
1 answer

VBA Help to find a column based on header value and cupy it to an other worksheet

You can break out the "copy column ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,600 points
2,905 views
0 votes
1 answer

How do I change the format of an excel workbook from 'General' to 'Text'

Only cells have a format for numbers. ...READ MORE

Mar 23, 2023 in Others by narikkadan
• 63,600 points
477 views
0 votes
1 answer

Loop through files using "" instead of Dir

Upon reading the documentation @Dir function (Visual ...READ MORE

Mar 20, 2023 in Others by narikkadan
• 63,600 points
605 views
0 votes
1 answer

Return value if scores contain value form min and Max column

So based on my comments above, here ...READ MORE

Mar 20, 2023 in Others by narikkadan
• 63,600 points
586 views
0 votes
1 answer

Copy data with filter applied using Excel VBA

Try this: Private Sub CommandButton1_Click() Dim ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
627 views
0 votes
1 answer

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

Consider using a fixed template for the ...READ MORE

Mar 20, 2023 in Others by narikkadan
• 63,600 points
558 views
0 votes
1 answer

Microsoft Excel - slow to open

We used to have a bat file ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
• 38,000 points
518 views
0 votes
1 answer

Runtime Error when trying to Loop Worksheets

Copy To Multiple Worksheets A Quick Fix Option Explicit Sub ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
600 views
0 votes
1 answer

Getting SUM for hh:mm:ss in EXCEL

The times are probably preserved as text. SUM ...READ MORE

Oct 23, 2022 in Others by narikkadan
• 63,600 points
6,938 views
0 votes
1 answer

Highlight cells in an Excel column if the value can be found in an array

Try this: =COUNTIFS(B:E,$A1) READ MORE

Feb 24, 2023 in Others by narikkadan
• 63,600 points
1,569 views
0 votes
1 answer

Filter date with time

Try this: Sub FilterInicioDeTurnoDAY() Dim in_time ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
555 views
0 votes
1 answer

GetObject(xxx).Application not working/recognizing open files

You can reference open Excel files in ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 63,600 points
1,549 views
0 votes
1 answer

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Confusion: You must declare the parameter as ...READ MORE

Mar 18, 2023 in Others by narikkadan
• 63,600 points
999 views
0 votes
1 answer

Delete table rows if time in column is >07:45

add a formula in a hidden column ...READ MORE

Mar 20, 2023 in Others by narikkadan
• 63,600 points
493 views
0 votes
1 answer

Add column from another table using excel power query

Use a left outer join to combine ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 63,600 points
1,523 views
0 votes
1 answer

How to automatically get a specified range of data from Excel to XML in VBA

Range method works, always identify the sheet ...READ MORE

Mar 18, 2023 in Others by narikkadan
• 63,600 points
973 views
0 votes
1 answer

Divide data and copy other cells in google sheets or excel

Try this : const Sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(`YourSheetName`) function dataHandler() ...READ MORE

Mar 20, 2023 in Others by narikkadan
• 63,600 points
456 views
0 votes
1 answer

VBA: Do While Loop does not want to looping

Try this: currentRow = 11 Do While originalSheet.Cells(currentRow, 1).Value ...READ MORE

Mar 18, 2023 in Others by narikkadan
• 63,600 points
941 views
0 votes
1 answer

Excel VBA compare values on multiple rows and execute additional code

I would use a Dictionary & Collection ...READ MORE

Feb 7, 2023 in Others by narikkadan
• 63,600 points
2,189 views
0 votes
1 answer

Autofill Copy down up until next empty row- Excel VBA Macro

Row 1048576 will be returned by end(xldown) ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,600 points
1,709 views
0 votes
1 answer

TODAY() function not working in Microsoft Excel

Works as shown: Just note that cell c1 ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
• 38,000 points
1,612 views
0 votes
1 answer

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

Dec 10, 2022 in Others by narikkadan
• 63,600 points
4,743 views
0 votes
1 answer

Export All appointments and meetings (including recurring meetings) Excel VBA

However, when I use the code above ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,600 points
1,871 views
0 votes
1 answer

VBA runtime error 1004 when copy and pasting

Try this: Sub CopyWorksheet() Dim ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,416 views
0 votes
1 answer

Degree of multiprogramming definition

In a multiprogramming-capable system, the jobs which ...READ MORE

Feb 11, 2022 in Others by Soham
• 9,710 points
17,647 views
0 votes
1 answer

Excel Script keeps giving error "Range merge: You cannot perform the requested operation."

Range.merge() Operation is not possible in ExcelScript ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,376 views
0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has ...READ MORE

Oct 2, 2022 in Others by narikkadan
• 63,600 points
7,615 views
0 votes
1 answer

How do I reference the cell value within a formula string?

Try: =HYPERLINK("#"&CELL("address",D116),B37) READ MORE

Feb 24, 2023 in Others by narikkadan
• 63,600 points
1,325 views