Recent questions tagged Excel

0 votes

802 views

1 answer

excel - Export chart as image - with click of a button

I'm trying to create a button that would export a chart in sheet "Graphs" as a jpeg file. This is the ... = Nothing End Sub Thanks everyone! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

793 views

1 answer

excel - How do I copy a range of formula values and paste them to a specific range in another sheet?

I'm trying to get an excel macro to work but I'm having an issue with copying the values from formula-containing ... , I'd appreciate it too. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

664 views

1 answer

excel - VBA editor auto-deletes spaces at the ends of lines

Is there a way to convince the VBA editor in Excel to stop auto-formatting lines to remove the space at the ... my typing for a quarter second? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

783 views

1 answer

excel - Extract the last substring from a cell

I have names in a column. I need to split just the last names from that column into another column. The last ... > David Mckenzie B3 -> Mckenzie See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

741 views

1 answer

excel - What's the difference between "end" and "exit sub" in VBA?

In VBA, sometimes we want to exit the program after some condition is true. But do I use end or exit sub? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

687 views

1 answer

excel - Writing a VLOOKUP function in vba

I'm trying to lookup a value on a spreadsheet within a table array using the VLOOKUP function in my vba code. I ... !AN2,DATA!AA9:AF20,5,FALSE) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

800 views

1 answer

excel - Writing a VLOOKUP function in vba

I'm trying to lookup a value on a spreadsheet within a table array using the VLOOKUP function in my vba code. I ... !AN2,DATA!AA9:AF20,5,FALSE) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

698 views

1 answer

excel - Creating form programmatically in the module using vba

I want to create a user form in the module using VBA programmatically. I am a novice and inexperienced so I ... to the form with a listener. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

631 views

1 answer

excel - Creating form programmatically in the module using vba

I want to create a user form in the module using VBA programmatically. I am a novice and inexperienced so I ... to the form with a listener. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

697 views

1 answer

excel - If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: ... from the same line that matched. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

709 views

1 answer

excel - Use Python to Inject Macros into Spreadsheets

I've got a macro that I'd like a bunch of existing spreadsheets to use. The only problem is that there are ... to me via the COM objects. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

620 views

1 answer

excel - Get content of a cell given the row and column numbers

I want to get the content of a cell given its row and column number. The row and column number are stored in ... () method as an excel Formula. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

748 views

1 answer

excel - Check whether a cell contains a substring

Is there an in-built function to check if a cell contains a given character/substring? It would mean ... when delimiting characters are absent. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

663 views

1 answer

excel - Comparing two columns on sheet1 to two other columns on sheet2 and returning another column in sheet 2.

I want to compare sheets1(a small list of names) First Name(Column A) and Last Name(Column B) to sheets2(a ... how to do it with two columns. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

619 views

1 answer

excel - How to send mail when the .Send does not work?

I am trying to send email through VBA. When the .Send wouldn't work, I found the Sendkeys method which works ... = Nothing Set OutApp = Nothing See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

626 views

1 answer

excel - How can I automate Save as dialog box in IE11 using VBA?

I am trying to download some data on carbon emissions. I can preload the page with the relevant settings via the ... :emp.xml Set IE = Nothing See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

568 views

1 answer

excel - Converting a string representation of a constant into a constant?

I'm trying to accept a formatting constant from a data cell, so I have a string "xlTotalsCalculationAverage". How ... to a known constant value? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

649 views

1 answer

excel - Can Advanced Filter criteria be in the VBA rather than a range?

After trying in vain to set more than 2 criteria in a normal AutoFilter fashion via VBA, I have come to ... check the preferred way first. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

542 views

1 answer

excel - Vlookup to copy color of a cell

I have the following tables: A B C D 1 Bob 1 6 Football 2 Nate 3 7 Baseball 3 Silver 3 2 Baseball 4 Box ... solution in VBA. I hope your help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

866 views

1 answer

excel - VBA - Run Time Error 1004 'Application Defined or Object Defined Error'

I have an Excel document that copies a template sheet into a new sheet on the first time it runs. Any more ... '. I'd appreciate any help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

700 views

1 answer

excel - OnTime for less than 1 second without becoming Unresponsive

I have a userform which runs a script every 100ms. The script handles images on the userform and is used to ... for this? Thanks in advance! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

647 views

1 answer

excel - Find last row in range

I'm having a little trouble with finding the last row. What I am trying to do is find the last row in ... think there is data in these cells? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

excel - Pandas read_excel with Hyperlink

I have an Excel spreadsheet that I am reading into a Pandas DataFrame: df = pd.read_excel("file.xls") ... the underlying hyperlink in Pandas? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

737 views

1 answer

excel - Copy worksheet from one workbook to another one using Openpyxl

I have a large amount of EXCEL files (i.e. 200) I would like to copy one specific worksheet from ... return status Any suggestions? Cheers See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

597 views

1 answer

excel - Running VBA from a HYPERLINK()

I'm trying to let my users send email easily from their Excel spreadsheets, which they like to use as front- ... time the user adds a record. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

630 views

1 answer

excel - Sending object array to variant works before August 2019 Windows update, but fails after update

Running the subroutine RunMe works before August 2019 Windows update. Running the subroutine RunMe fails after August 2019 ... Is there a fix? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

712 views

1 answer

excel - Uncheck all checkboxes across entire workbook via CommandButton

I would like to have a code that unchecks all checkboxes named "CheckBox1" for all sheets across the workbook. ... End Select Next End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

904 views

1 answer

excel - Splitting String in VBA using RegEx

I'm new to VBA and would like to seek some help with regards to using RegEx and I hope somehow can ... settings of the user's computer. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags