Recent questions tagged Excel

0 votes

746 views

1 answer

excel - Copy a range of cells and only select cells with data

I'm looking for a way to copy a range of cells, but to only copy the cells that contain a value. In my ... B, and continues in the same way. See Question&Answers more detail:os...

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

0 votes

847 views

1 answer

excel - Format(SomeDate,"MM/dd") = "12-15" in VBA

I'm writing a VBA macro in Excel that analyzes data from the spreadsheet and sends an email. In this macro, I have ... of "12/15" as expected. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

excel - No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#

I'm trying to connect to a running Excel instance, but when I try to use the following code snippet: ... .Excel - System.Runtime.InteropServices See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Setting a chart source data based on a variable cell range in VBA

I am creating a report template part of which will be generating data charts with a structure similar to a ... my report purposes, please help See Question&Answers more detail:os...

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

0 votes

701 views

1 answer

excel - Tables interfere with VBA range variables depending on scope

An Excel file includes VBA-coded user-defined functions (UDFs) that are deployed in tables (VBA listobjects). ... and shared valuable ideas. See Question&Answers more detail:os...

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

0 votes

905 views

1 answer

excel - Insert text into the background of a cell

I am looking for a way to insert text into the background of a cell, so that I can still enter numbers on ... open to these solutions as well)? See Question&Answers more detail:os...

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

0 votes

791 views

1 answer

excel - How to paste the selected range (passed as rng) to the end of the worksheet?

The code below is trying to paste the selected range (passed as rng) to the end of the worksheet. It works if ... there are less than 2 rows. See Question&Answers more detail:os...

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

0 votes

712 views

1 answer

excel - VBA: How to use the Object Browser?

I don't know if this is the right place for my question, but: how do I use the object and the browser? I ... is/can be a property of ChartArea? See Question&Answers more detail:os...

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

0 votes

956 views

1 answer

excel - Find first non-blank cell in a range

I am working with a list of data where one or multiple cells in a row can be blank. Lets say the list is ... empty I want it to return A4. See Question&Answers more detail:os...

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

0 votes

748 views

1 answer

excel - Set background colour of cell to RGB value of data in cell

I have a column containing RGB values, e.g.: 127,187,199 67,22,94 In Excel, is there any way I can ... set the background colour of the cell? See Question&Answers more detail:os...

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

0 votes

787 views

1 answer

excel - How to get current working directory using vba?

I am using MS Excel 2010 and trying to get the current directory using the below code, path = ... But ActiveWorkbook.Path returns blank. See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

excel - Date formats/values change when file is opened programmatically

I have .csv file which is a time series of daily data, with several data points associated with each date. ... the line Workbooks.Open(File). See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Assign 1D array from 2D array in VBA?

So maybe its monday, maybe I'm stupid.. But I can't for the life of me figure out a good way to get a ... loop that I don't like? Thanks! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Finding partial text in range, return an index

I need to find a partial text in a specific range and get a value which is X rows under cell index of found text ... . Any ideas how to do this? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Border around each cell in a range

I am trying to create a simple function that will add borders around every cell in a certain range. Using the wonderful ... + 1 End If Next I See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Setting Column width in Apache POI

I am writing a tool in Java using Apache POI API to convert an XML to MS Excel. In my XML input, I receive ... I have to convert to MS Excel. See Question&Answers more detail:os...

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

0 votes

893 views

1 answer

excel - Substitute a comma with a line break in a cell

In the cell below, I want to get whatever is separated by a comma to come to a new line. I can add these line ... ,Duration:00:52:50,SLA:1 Hour. See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

excel - Delay macro to allow events to finish

While attempting to access an external API function set from within a macro I found it necessary to add in a ... how can I implement this? See Question&Answers more detail:os...

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

0 votes

969 views

1 answer

excel - How to open chrome with extension using selenium VBA

I am very new to programming, so what I trying do is open chrome with extension. After doing some search i found ... ... Thanks in advance .. See Question&Answers more detail:os...

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

0 votes

728 views

1 answer

excel - Merge Multiple Workbooks From Different Folders Into One

I wonder whether someone may be able to help me please. I'm using the code below to allow a user to ... this. Many thanks and kind regards See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

excel - Error 438 when trying to call a sub method from a module class with parameters

I get error 438 : Object does not support this property or method when trying to run the following code. Could ... is quoted above. None works. See Question&Answers more detail:os...

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

0 votes

770 views

1 answer

excel - Sum of numbers + 0

I am having a problem with a small number. I am using SUM function to sum certain numbers. If I add a zero to ... A2 and A3 displays 9.09E-13 See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

excel - A function within a function in vba?

Here is a simplified version of a function I use in a cell (=xxDay(B7) for example) to retrieve a day ... End Sub Much appreciate any response. See Question&Answers more detail:os...

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

0 votes

889 views

1 answer

excel - Fail to get csv from S3 and convert it with Python

I need to read csv file from s3 bucket and insert each row on dynamoDB def load_users_dynamodb(): s3 = boto3.client( ... can help me please? o/ See Question&Answers more detail:os...

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

0 votes

748 views

1 answer

excel - PivotCaches.Add Errors out

I'm using excel 2013 and I am getting invalid procedure call or argument while calling PivotCaches.Add Set objExcel ... Visible = False End With See Question&Answers more detail:os...

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

0 votes

680 views

1 answer

excel - AutoFilter based on an array, more than 3 elements

EDIT: My variables contain wildcards. I saw something online that says that if I am using wildcards, the ... is not with the variables. See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

excel - Delete large number of rows (e.g. ~500k rows) based on a certain criteria

I have a large number of rows and columns (e.g. 500k rows and 20 columns) all filled with numbers. ... Application.ScreenUpdating = True End Sub See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

excel - VBA - Loop Each Item in Pivot Filter and Paste into new sheet

I have a challenge... I have a range in Sheet Lookup with each possible value in Pivot table filter "Owner: ... End With Next rng End Sub See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags