Recent questions tagged Excel

0 votes

755 views

1 answer

excel - Insert vertical slices into array

In a recent post I demonstrated how to use array arguments in the Application.Index() function (instead of ... the Application.Index() function See Question&Answers more detail:os...

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

0 votes

815 views

1 answer

excel - Multi-Criteria Selection with VBA

I have created a macro that allows me to open multiple files based on their names and copy sheets into one on ... sheet. Thanks for your help See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

excel - Cutting Row with Data and moving to different sheet VBA

I'm trying to cut a row that has the specified cell blank and then paste it into another sheet in the same ... End Sub Thanks for any help! See Question&Answers more detail:os...

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

0 votes

925 views

1 answer

excel - VBA InternetExplorer.Application Object Hang

I'm using an old Excel document with VBA that works fine with IE 11 on Windows 7, however on IE 11 ... and W10 machines with identical results. See Question&Answers more detail:os...

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

0 votes

914 views

1 answer

excel - Array formula result concatenated into single cell

Is it possible to take the return values from an array formula and concatenate them into a single cell? For example, ... MATCH(A3,$C2:$C999,0))) See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

excel - Only unique records in a Combobox (VBA)

I have a combobox where I add some stuff from an Excel sheet with a bunch of stuff. I want only unique records ... more items. Where am I wrong? See Question&Answers more detail:os...

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

0 votes

850 views

1 answer

excel - VBA Project Password-Protect with SendKeys not Working Correctly

I've spent the last two days working on this problem. Most of the content I've found on this topic doesn't ... doesn't appear to have helped. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - syncing two lists with VBA

What is the best way to sync up two lists each of which may contain items not in the other? As shown the lists are not ... : a b b c c d e e See Question&Answers more detail:os...

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

0 votes

916 views

1 answer

excel - How to programatically re-enable documents in the MS Office list of disabled files

MS Office programs keep a list of disabled files that have caused errors when previously opened. A user can ... interaction with the gui? See Question&Answers more detail:os...

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

0 votes

926 views

1 answer

excel - How to read files with .xlsx and .xls extension in Azure data factory?

I am trying to read and excel file in Azure Blob Storage with .xlsx extension in my azure data factory dataset ... be read in azure Data factory See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

excel - Find where named ranges are being used in big workbook

I have a list of 594 named ranges in a workbook with nearly 20 sheets, each sheet has about 200 columns of data. I need ... a) b = b + 1 Next a See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Non-Intersect Range VBA

In the below code rngIntersect.Address returns A10. Is there way where in i can get all ranges excluding ... MsgBox rngIntersect.Address End Sub See Question&Answers more detail:os...

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

0 votes

993 views

1 answer

excel - How to identify the clicked shape name in VBA

I am trying to create an excel template where I have already assigned different macros to different shape that act as ... in VBA? Thank you! See Question&Answers more detail:os...

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

0 votes

896 views

1 answer

excel - What's the difference between Range.Item and Range.Cells?

For example, in the code below, Item and Cells can be used interchangeably: Dim rRange As Range Set rRange = ... 1)? What am I missing? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - How to write Fortran Output as CSV file?

Can any one tell me, how can I write my output of Fortran program in CSV format? So I can open the CSV file in Excel for plotting data. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Test if range exists in VBA

I have a dynamically defined named range in my excel ss that grabs data out of a table based on a start date ... ' of object '_Global' failed." See Question&Answers more detail:os...

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

0 votes

759 views

1 answer

excel - Using post data and xlmlhttp

I am still trying to learn more about scraping and I could devise a code that enables me to get the desired ... choices for the search process. See Question&Answers more detail:os...

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

0 votes

795 views

1 answer

excel - Copying worksheets from multiple workbooks into current workbook

Copying worksheets from multiple workbooks into current workbook Hi I was wondering if anybody if you guys could help me ... = Dir Loop End Sub See Question&Answers more detail:os...

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

0 votes

887 views

1 answer

excel - VBA, search in column for specific character, extract string upto that character

In a specific column, I want to search for a specific character in cells...say "(" or "/". Once this ... , are not of a specific length. See Question&Answers more detail:os...

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

0 votes

916 views

1 answer

excel - Convert multiple xls to csv using powershell

I'm trying to convert multiple excel files (xls) to csv which is located in a folder using powershell. I ... .Close($false) $ExcelWB.quit() See Question&Answers more detail:os...

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

0 votes

922 views

1 answer

excel - How to restore VBA Editor to its initial settings?

How to restore the VBA Editor to its intial settings ? I have some troubles with macro and projects explorer ... , after some bad manipulations. See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

excel - Pivot Calculated formula: SUM(Field1)/AVG(Field2)

I've a simple table with some amount and interval in sec by date and product name. Month | Product | Amount | ... in sec'. How to achieve this? See Question&Answers more detail:os...

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

0 votes

810 views

1 answer

excel - Creating a self install macro?

Hello I create many macros for my co workers. The current method I have for distributing to another computer is ... ideas are welcome! Thanks! See Question&Answers more detail:os...

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

0 votes

998 views

1 answer

excel - print all conditional formatting rules for a spreadsheet

I would like VBA code to print every condition formatting Rule within a spreadsheet, including Rule Type, Rule ... do I achieve this? See Question&Answers more detail:os...

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

0 votes

679 views

1 answer

excel - Why can't I `End` code while I'm subclassing without breaking everything?

Context I've written some code in VBA to subclass a userform so that ultimately I can intercept WM_TIMER ... my SUBCLASSPROC should too. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Use formula in custom calculated field in Pivot Table

In Excel Pivot table report there is possibility for user intervention by inserting "Calculated Field" so that user ... of all targeted cells ? See Question&Answers more detail:os...

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

0 votes

944 views

1 answer

excel - Getting the number of filled cells in a column (VBA)

My first column is an index, with monotonously increasing numbers, which ends at a non predictable point. Now I want ... out for an empty cell? See Question&Answers more detail:os...

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

0 votes

916 views

1 answer

excel - VBA enums give occasional "Constant Expression Required" errors

I'm using an enum defined in a class module in Excel VBA. This has been working fine, but I've started getting ... like it is a rare problem. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags