Trending questions in Others

0 votes
1 answer

Python: Converting Datetime into an integer

Try this: import datetime current_date = datetime.datetime.now() print("String Format of ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,642 views
0 votes
1 answer

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Range(...) instructs VBA to always use the ...READ MORE

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

Embed picture in outlook mail body excel vba

The image needs to be added and ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 6,381 views
0 votes
1 answer

VBA - Dynamic Variable Name in a Loop

Set the array values with: Dim i as ...READ MORE

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

Two different fonts in one cell using excel vba

Public Sub add_degree_symbol() ActiveCell.Value = ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,379 views
0 votes
1 answer

Way to run Excel macros from command line or batch file?

Solution Open the workbook and run the macro ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 7,723 views
0 votes
0 answers

How do I use text as reference in EXCEL

How can I reference one text-based cell ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,325 views
0 votes
0 answers

Copying values from multiple excel files to a single one with python

I want to replicate the values from ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,214 views
0 votes
1 answer

Get column names of Excel worksheet with OpenPyXL in readonly mode

This will print every thing from row ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 86,360 points • 8,591 views
0 votes
1 answer

Openpyxl password protect excel file python

Workbooks can be secured against certain actions, ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 9,801 views
0 votes
0 answers

ExcelDataReader, can't read "html-format" file

I have the following code: ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,134 views
0 votes
1 answer

How to run Macro when press enter automatically and paste in different cell

A Worksheet Change: Keep Record of Each ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,081 views
0 votes
1 answer

Convert Yaml to excel in Python

You can try this: First, install dependencies: pip install ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,667 views
0 votes
1 answer

How to programmatically get the values of a spilled Excel range in VBA?

By using the Text property, I was ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 86,360 points • 1,817 views
0 votes
0 answers

List files in specified directory without subdirectories

How can I only go through files ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 995 views
0 votes
1 answer

Plot multiple datasets on the same chart with VBA

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

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,204 views
0 votes
1 answer

How to format calculated land size in excel

To get hectare (F2): =A2+QUOTIENT(B2*100+C2,10000) or =QUOTIENT(A2*10000+B2*100+C2,10000) To get are (G2): =QUOTIENT(MOD(B2*100+C2,10000),100) To ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,363 views
0 votes
1 answer

VBA Check to see if file is open before reopening a second file

You could replace the line: Set pre = ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,278 views
0 votes
1 answer

Excel worksheet multi-criteria function (like Index-Match array) to fetch last value of an item, looking up by item name and date

Use: =SUMIFS(C:C,B:B,E12,A:A,MAXIFS(A:A,B:B,E12)) It will return the value at the ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,189 views
0 votes
1 answer

How to get subscript into formulas text string

Convert Digits To Subscript (H₂SO₄) Excel Formula Improvement ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,302 views
0 votes
1 answer

Modify table data in excel sheet by userform

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

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,317 views
0 votes
1 answer

Excel Nested IF INDEX MATCH Function

Use COUNTIF and an array if all ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,357 views
0 votes
1 answer

Split the column cell value of location in 3 different columns

If the Location column has always the same pattern, ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 999 views
0 votes
1 answer

How to pass a JSON-formatted string from Excel VBA as argument to a MySQL Store Procedure

Set the parameter length to the json ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,287 views
0 votes
1 answer

Document changes in a graph excel

To be able to trace changes, the ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 935 views
0 votes
1 answer

Arrange charts position in 3x5 order

Your code was nearly complete. I believed ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 975 views
0 votes
1 answer

How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

See Conditional Formatting, which may be accessed ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,060 views
0 votes
1 answer

Find specific term in a text string and return that term in the previous column

Try: You can either hard code the ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 903 views
0 votes
1 answer

Copying only one column of Userform ListBox data to single cell in separate spreadsheet with commas separating data

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

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 942 views
0 votes
1 answer

Loops through Check Box in VBA

Please attempt the next option. Assuming you ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,284 views
0 votes
1 answer

Combing data from multiple workbooks into a single master workbook using power query

PowerQuery would scan the contents of all ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,022 views
0 votes
1 answer

Not Like has no effect while looping an Array

you can add parentheses instead... mixing an ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 889 views
0 votes
1 answer

Excel VBA SQL Query on not saved Workbook

What can I do to get the ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,014 views
0 votes
1 answer

Why is my excel calculation bringing back a "value" other than zero?

Column D's formula should be changed so ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 912 views
0 votes
1 answer

Count Function for identifying the Unique values in Excel

If the 9th row is empty: =COUNTA(UNIQUE(TOCOL(F8:R10)))-1 If not ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,037 views
0 votes
1 answer

VBA Regular Expression to return ALL matching patterns

You have set the global to false, ...READ MORE

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

Check if cell found is in column "AP"

Find the Last Cell in the Row ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,105 views
0 votes
1 answer

Conditional formatting on a calculation in excel

In E5, you could use =IF(COUNTBLANK(E3:E4)=0,E3-E4,"") which would ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,214 views
0 votes
1 answer

excel not reading some data

When using the sep option in the ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 824 views
0 votes
1 answer

Excel: importing data from another Excel file using VBA

Refer to the file variables folderName and ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 950 views
0 votes
1 answer

Copying an existing row which also copies the checkbox with its code

You can make a new checkbox object ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,152 views
0 votes
1 answer

VBA Repeatable Function on button click

Remove Duplicates Based on a Single Column The ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 838 views
0 votes
1 answer

Conditional formatting based on value with offset

Apart than the altered cell, Conditional Formatting ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,046 views
0 votes
1 answer

Select data that meet criteria from a table, adding it to a combobox in userform VBA Excel

Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,434 views
0 votes
0 answers

Why does Excel give me a #NAME? error when I open this CSV file?

The CSV file consists of two lines: ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 745 views
0 votes
1 answer

Use AutoFilter on the current visible data

Use the following modified code. It's assumed ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 781 views
0 votes
0 answers

VLOOKUP with date range does not work as intended

I have two excel tables in separate ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 773 views
0 votes
1 answer

Error Trying to Display The Names of All Excel Data Models in a Workbook

It is necessary to list ThisWorkbook.model. Not ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 774 views
0 votes
1 answer

Conditional Formatting not applying to all the cells in a given range

Use the following instead as the Formula: =$P5=75% I ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 900 views
0 votes
1 answer

Open Existing PowerPoint via VBA

You do not have the proper reference ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,485 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.