Recent questions tagged Excel

0 votes

785 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

727 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

715 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

946 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

737 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

788 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

756 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

701 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

646 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

915 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

688 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

773 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

709 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

861 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

675 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

756 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

949 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

660 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

926 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

698 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

698 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

711 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

854 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

576 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

784 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

889 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

737 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