Trending questions in Others

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 • 1,514 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 86,360 points • 3,998 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
 • 86,360 points • 1,419 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 • 1,459 views
0 votes
1 answer

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 8,155 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
 • 86,360 points • 2,446 views
0 votes
1 answer

How to scrape the specific text from kworb and extract it as an excel file?

The best practice to scrape tables is ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 86,360 points • 2,690 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

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

CodeIgniter: Unable to connect to your database server using the provided settings Error Message

 I'm assuming there is something wrong with ...READ MORE

Feb 16, 2022 in Others by Soham
 • 9,730 points • 18,492 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 • 1,322 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
 • 86,360 points • 1,356 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
 • 86,360 points • 1,135 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
 • 86,360 points • 1,212 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 • 1,385 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
 • 86,360 points • 1,326 views
0 votes
1 answer

EXCEL Userform - Creating multiple Labels and Textboxes with specific names

Please, test the next scenario: Insert a class ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 86,360 points • 3,002 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
 • 86,360 points • 2,351 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 • 1,260 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
 • 86,360 points • 1,794 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
 • 86,360 points • 1,286 views
0 votes
1 answer

Send message using excel to whatsapp web reloading

Inputs Range("W_C") = A list of Contacts' telephone ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 86,360 points • 9,069 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
 • 86,360 points • 1,047 views
0 votes
1 answer

How to increment the Range of a For Each loop - Excel VBA

Your formula seems to sum 1 single ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 86,360 points • 4,343 views
0 votes
1 answer

Django upload and process multiple files failing with libreoffice

The problem happens when LibreOffice tries to ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 2,435 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
 • 86,360 points • 1,218 views
0 votes
1 answer

Converting excel to pdf using PHP

If utilizing PHP on a Windows PC, ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 86,360 points • 7,596 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

The UDF to use. The default separator is ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 86,360 points • 3,117 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
 • 86,360 points • 2,209 views
0 votes
1 answer

Delete all rows in filtered range Except first filtered row in excel VBA

Use a flag to omit first row Sub ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 86,360 points • 4,228 views
0 votes
1 answer

Export DataFrame timedelta column to timestamp Excel column

The reason that the column format isn't ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 2,965 views
0 votes
1 answer

Filter outlook sent items in vba failing for emails with multiple recipients

The PR DISPLAY TO parameter provides a ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 86,360 points • 2,316 views
0 votes
1 answer

Create numbered XML nodes, set attributes when creating XML node

Just like createElement, createAttribute is a method of the xml ...READ MORE

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

VBA Excel: Draw line between cells based on cell value

In accordance with your description and with ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 2,942 views
0 votes
1 answer

EXCEL - Is there a formula for TEXTSPLIT from 3 different rows into a sequencing of rows without data /text duplication?

SORT a UNIQUE TEXTSPLIT To Column Simple Be aware ...READ MORE

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

Excel VBA: Obtain the Column and Row of current element in "For Each" loop

Try this: MsgBox rng.Address(RowAbsolute:=False, ColumnAbsolute:=F ...READ MORE

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

VBA Copy/Paste a Range in Next Available Column Then Add a Single Day to One of the Newly Pasted Cells Repeatedly

With a date you can treat it ...READ MORE

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

How to Convert nested JSON into excel in nodejs

Try this: const filtered = attendanceData.map(obj => { ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 4,589 views
0 votes
1 answer

Modifying Excel document using python and openpyxl

The style will be set to Hyperlink ...READ MORE

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

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 86,360 points • 7,660 views
0 votes
1 answer

How to get all Stock list company name and symbol of NSE and BSE with free API?

Check the below link for your answer: http://www.barchartondemand. ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 6,490 views
0 votes
1 answer

Excel formula exceeds 8000 characters limit

Using auxiliary columns to divide the formula ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 86,360 points • 2,162 views
0 votes
1 answer

VBA Comment Format

Let's say you're having trouble referencing every ...READ MORE

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

The delete method of the range class failed in vba

Delete Criteria Rows Efficiently Sub DeleteCriteriaRows() ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 86,360 points • 2,156 views
0 votes
1 answer

Reshaping/Deduping long data to wide in R

Using pivot_wider and rename library(dplyr) library(tidyr) repl <- c("1st_transaction" = "type_1", "2nd_transaction" = ...READ MORE

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

Is there a faster way to delete table rows so my script doesn't take hours to run?

This is for your rowAddressToRemove variable. So instead of ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 3,061 views
0 votes
1 answer

Populating table or range to listbox in userform to get the values of the columns inside the table or range in closed workbook

Because rs.RecordCount is of type LongLong, which ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 2,014 views
0 votes
1 answer

How to remove borders from cells in a range in Excel using VB.net?

range.Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeRight).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeTop).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeBottom).LineStyle ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 86,360 points • 4,144 views
0 votes
1 answer

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 3,711 views
0 votes
1 answer

How to make an error flagging array in VBA and translate all array elements as a string message?

In my opinion, using an array in ...READ MORE

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

How do I get text in a pivot table in excel or google sheets?

Try: =QUERY(QUERY({Data!A:A, Data!Q:S}, "select Col4,max(Col1) ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 2,750 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.