Recent questions tagged Excel

0 votes

790 views

1 answer

excel - Macros Not Showing Up in Macro Table

I am writing VBA macros in excel 2016. Macros I write that have arguments do not show up in the Macro Table, ... that have no arguments. Help. See Question&Answers more detail:os...

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

0 votes

736 views

1 answer

excel - How to check if a cell has a picture?

In Excel, I want to check if a specific cell for instance "C12" has a picture? How could I do this? See Question&Answers more detail:os...

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

0 votes

718 views

1 answer

excel - Speed up pivot table filtering VBA code

I have a pivot table with a pivot field and contain many items. I've VBA code logic to decide if the pivot ... = False but didn't work. See Question&Answers more detail:os...

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

0 votes

952 views

1 answer

excel - VBA Saving single sheet as CSV (not whole workbook)

I appreciate there are lots of entries like save individual excel sheets as csv and Export each sheet to a ... Windows 10 and Office 365 See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

excel - VBA-Change color of cells based on value in particular cell

I want to change the background colors of cells A2:C2 based on the value of cell D2. This also applies ... can copy-pasta into future reports. See Question&Answers more detail:os...

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

0 votes

796 views

1 answer

excel - Concatenate multiple results from an index match

I'm trying to concat multiple results from an index match into one cell. Here is an example data set I' ... out how to concatenate the customer. See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

excel - Need a macro to detect if cell value changes from current value

I need help with an macro to notify me (by changing a cell background color to red), when the value (always ... . Any help is much appreciated! See Question&Answers more detail:os...

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

0 votes

714 views

1 answer

excel - Slow VBA macro writing in cells

I have a VBA macro, that writes in data into a cleared out worksheet, but it's really slow! I'm instantiating ... know. Thank you for your time. See Question&Answers more detail:os...

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

0 votes

650 views

1 answer

excel - Converting VBA Collection to Array

I am trying to create an array with all the worksheet names in my workbook that have the word 'Template' ... collectionToArray = a End Function See Question&Answers more detail:os...

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

0 votes

923 views

1 answer

excel - Filtering between two dates in pivot table using VBA. UK to US date format issue

I have found a workaround for this but if anyone has a cleaner way of doing this I'd be interested/grateful. ... craziness I'd be much obliged! See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

excel - move files from one folder to another

actually I am searching for code to move excel files from one folder to another if there is any way to do so ... . I will be grateful to you See Question&Answers more detail:os...

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

0 votes

784 views

1 answer

excel - Copy/PasteSpecial vs Range.Value = Range.Value

I've read a number of times on this site (and elsewhere) that it's best to avoid copy/paste if ... = cyTicks1 / cyFrequency End Function See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

excel - VBA setting the formula for a cell

I'm trying to set the formula for a cell using a (dynamically created) sheet name and a fixed cell ... direction would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

excel - VBA Integer Overflow at 70,000

I have a worksheet with 70,000 rows of data and a simple macro that counts the total number of rows: Dim ... so why would it fail? Thanks! See Question&Answers more detail:os...

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

0 votes

677 views

1 answer

excel - How to send a Word document as body of an email with VBA

I've created a macro that works with outlook and excel that will use a list of email addresses (in excel) ... in tact and the images included? See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

excel - VBA paste range

I have simple goal of copying range and pasting it into another spreadsheet. The following code below gives copies ... End Sub Any suggestions? See Question&Answers more detail:os...

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

0 votes

959 views

1 answer

excel - How to call a Macro from Apache POI library in Java?

I have : Macro named "process" that does all the processing work for my worksheets. I want my Java code that ... Apache POI and Java itself.) See Question&Answers more detail:os...

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

0 votes

668 views

1 answer

excel - Get the current Workbook Object in C#

I've been writing an application in C# which creates Custom Document properties in an Excel spreadsheet, I have ... valid Workbook COM object. See Question&Answers more detail:os...

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

0 votes

933 views

1 answer

excel - Open CSV file via VBA (performance)

Obviously, this question has been asked many times. The normal procedure: Workbooks.Open (ActiveWorkbook.Path & " ... Excel with right parsing? See Question&Answers more detail:os...

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

0 votes

702 views

1 answer

excel - vba pass a group of cells as range to function

I'm getting a group of cells and doing some calculations over them in function below. It works if I pass a ... of ranges as a parameter? how? See Question&Answers more detail:os...

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

0 votes

706 views

1 answer

excel - Automatically add `Option Private Module` to all modules in VBA

Is there a way automatically to add Option Private Module to all modules in VBA? Something like the automatic ... save some 30 minutes here? See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

excel - VBA macro to mass update multiple files in same location

Very new to this so please help. Im trying to mass update files in a static folder location, many files in ... file from the network location. See Question&Answers more detail:os...

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

0 votes

864 views

1 answer

excel - Does VBA have a Hash_HMAC

Hi I am trying to Encrypt a string to invoke a web service from VBA. I need to do the following ... ); $hash = base64_encode($binaryHash); See Question&Answers more detail:os...

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

0 votes

583 views

1 answer

excel - What does the keyword 'New' do in VBA?

In VBA procedures we are constantly meeting the keyword New usually on instantiation of an object reference to an existing ... to post pic :-( See Question&Answers more detail:os...

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

0 votes

795 views

1 answer

excel - Alternate Row Colors in Range

I've come up with the following to alternate row colors within a specified range: Sub AlternateRowColors() ... .Interior.ColorIndex = xlNone See Question&Answers more detail:os...

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

0 votes

907 views

1 answer

excel - Convert month name into number

I have dropdown box with months populated. When a month is selected I would like to then convert it to the month ... do this? Eg. September = 9 See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

excel - Format cell color based on value in another sheet and cell

I have a workbook with two sheets. I would like to format the cell background color in the first column of sheet ... isn't worth it. Thank you! See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

excel - Read in .xlsx with csv module in python

I'm trying to read in an excel file with .xlsx formatting with the csv module, but I'm not having any ... 570-571: illegal UTF-16 surrogate See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags