Recent questions tagged Excel

0 votes

662 views

1 answer

excel - Submitting data via IE to an online MS Form is not working

Can anyone figure out what I am doing wrong? When I try to submit data to an online MS Form the submission ... kill exe End If Next End Sub See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

excel - Trying to fill text in input box with dynamic drop down

I need some help. Chrome (v 75.0.3770.100) using Selenium Basic ChromeDriver (v 75.0.3770.140) ... "custAddresses" data-validation="required"> See Question&Answers more detail:os...

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

0 votes

660 views

1 answer

excel - Incorrect result from CurrentRegion when used in a function called from a cell

I'm trying to write a VBA function to be called from a cell. In this function I need to use the ... A1 is selected. Any ideas anyone? See Question&Answers more detail:os...

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

0 votes

647 views

1 answer

excel - Using Restrict method for emails within a specified date

I am creating a macro to get email by subject and received date in our team shared box. My problem is that ... Set OutlookApp = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

739 views

1 answer

excel - Copy VBA code from one Worksheet to another using VBA code

Ok here is what I want to accomplish: I am trying to copy all the VBA code from "Sheet2" to " ... VBComponenets("Sheet3").CodeModule = CodeCopy See Question&Answers more detail:os...

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

0 votes

750 views

1 answer

excel - UDF using FindNext seems to abort without warning

I have the following user-defined function, which attempts to find the nth non-empty cell in a range: ... function abort without any warning? See Question&Answers more detail:os...

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

0 votes

644 views

1 answer

excel - VBA code string to cell not working - run time error 1004

I'm trying to accomplish something very simple. Actually it used to run normally but when I changed to windows 7 ... for me. Any ideas ? thanks See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

excel - Identifying a worksheet other than by its name

A worksheet can be identified by its name such as in this example: Dim mysheet As Worksheet Set mysheet = ... obviously won't work anymore. See Question&Answers more detail:os...

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

0 votes

848 views

1 answer

excel - Copy format from one row to another using c#

This question is quite similar to the one asked here. But the answer given suggests copying the format along with ... I am using Excel interop. See Question&Answers more detail:os...

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

0 votes

907 views

1 answer

excel - Using string array as criteria in VBA autofilter

I've searched other posts and found similar issues but nothing that could help me specifically. I'm trying ... recent option remains checked. See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

excel - Improving the performance of FOR loop

I am comparing sheets in a workbook. The workbook has two sheets named PRE and POST with the same 19 ... .ScreenUpdating = True End Sub See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

excel - How do you get just the filename rather than the entire file path of an open file?

In other words, would I need to do some string processing after invoking the Application.GetOpenFileName() Method? See Question&Answers more detail:os...

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

0 votes

683 views

1 answer

excel - How to populate data from a range (multiple rows and columns) to listbox with VBA

I am having trouble with how to put the data from the range with multiple columns and rows to a listbox. Assume ... but it did not work either. See Question&Answers more detail:os...

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

0 votes

874 views

1 answer

excel - iReport (JasperReports) extra row issue

I am getting an extra empty row between data when I am importing it from the database and formatting the ... extra blank column between fields. See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

excel - VBA: Inconsistent error 91 in loop w/ IE.doc reference

I freely admit that I am not too experienced with the HTML Object Library. I have a spreadsheet with IRS ... Nothing End Sub Any suggestions? See Question&Answers more detail:os...

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

0 votes

893 views

1 answer

excel - VBA Print to PDF and Save with Automatic File Name

I have a code that prints a selected area in a worksheet to PDF and allows user to select folder and input file ... ("D4:E4").Select End Sub See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

excel - What to do when autofilter in VBA returns no data?

I am trying to filter a range of values and based on my criteria, at times I might have no data that fits ... guidance on how to solve this. See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

excel - VBA Convert date to week number

In VBA I want to convert a date as 03/11/2017(DD/MM/YYYY) into the week number for that date. Until now ... the year. First week day is Monday. See Question&Answers more detail:os...

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

0 votes

790 views

1 answer

excel - Count a list of cells with the same background color

Each cell contains some text and a background color. So I have some cells that are blue and some that are red. ... success (Where D3 is red). See Question&Answers more detail:os...

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

0 votes

782 views

1 answer

excel - Using VBA to check if below cell is empty

How do I use VBA in Excel to check if a below cell is empty or not? I want to sum all values in a specific range, but ... be: 4 + 3 + 2 = 9. See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

excel - Use solver in VBA with loop in rows

I am trying to use solver to find the root for 182 cells, each cell is depend only on one another ... converge. Any help is appreciated. See Question&Answers more detail:os...

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

0 votes

687 views

1 answer

excel - VBA: Usage of parentheses for a method

What's the right way to call method when it comes to using or omitting parentheses? If I understand the results ... At this I'm just confused. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Can't find Microsoft Forms 2.0 Object Library or FM20.DLL

In my Excel 2016 project (Windows 7), I'd like to work with the clipboard: Dim DataObj As New MSForms.DataObject ... How can I make it appear? See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

excel - Use INDEX MATCH to find greater than/equal to value

I've been searching online and in Excel Help but cannot find whether this is possible. Given a list of numbers, ... to read in ascending order. See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

excel - ExecuteComplete ADODB Connection event not fired with adAsyncExecute parameter

I have a problem trying to catch the completion of a stored proc execute asynchronously. Below my code VBA (in a ... how to solve my question? See Question&Answers more detail:os...

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

0 votes

790 views

1 answer

excel - Turn off screenupdating for Powerpoint

I am writing a script that loops through a folder and creates graphs from some criteria, and then exports these to ... , now I need your help! See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Why am I getting Error 2042 in VBA Match?

I have Column A: +--+--------+ | | A | +--+--------+ | 1|123456 | |--+--------+ | 2| ... (Cstr(CurrentShipment), Range("A1:A5"), 0) to no avail. See Question&Answers more detail:os...

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

0 votes

973 views

1 answer

excel - What does the number in the AddChart2 VBA macro represent?

I've use my Excel 2013 to record a macro in inserting a chart, a column-clustered chart in my case. In ... me what does the number represent? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags