Recent questions tagged Excel

0 votes

924 views

1 answer

excel - How to clear the VBA code of a worksheet via a macro?

I have a file where there's a template sheet that needs to run some code when it's activated. This sheet is ... the VBA code of a worksheet. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - VBA pasting 3 dimensional array into sheet

I have a 3 dimensional array (5 x 5 x 3) and I need to post (5 x 5 x 1) to Sheet1, (5 x 5 x 2) to ... 1), Cells(5, 5)) = arr Next End Sub See Question&Answers more detail:os...

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

0 votes

855 views

1 answer

excel - Validation message of text box entry on modeless form interrupts text selection

Hi I try this code in my Userform to check if Data entered in textbox1 is a number and if is not show a ... End If End Sub is any solution? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - How to add a dropdown list to google sheet using Google Sheets API python

Using Google Sheets API python How to add a dropdown list to google sheet with list items [YES. NO, MAYBE] ... something like this : Thank you! See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

excel - VBA vlookup reference in different sheet

In Excel 2007, I am looping through the values of column 4 in Sheet 2. Still in Sheet 2, I want to output ... to a different sheet in this case? See Question&Answers more detail:os...

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

0 votes

792 views

1 answer

excel - Get the maximum values of column B per each distinct value of column A

I have an Excel spreadsheet of the form: A,B X,1 X,5 Y,4 Y,11 X,7 Z,1 I would like to ... understanding of formula programming in Excel. No VBA See Question&Answers more detail:os...

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

0 votes

992 views

1 answer

excel - Error when I use SpecialCells of AutoFilter to get visible cells in VBA

My main goal is to copy the visible cells of an autofilter and later copy the dimensions of the visible ... execute again the autofilter? See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

excel - Convert an array of bytes into a string?

I have arrays of integers, each is a ASCII code representing a single byte of a string. I can generate a ... to produce the string with VBA? See Question&Answers more detail:os...

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

0 votes

674 views

1 answer

excel - vba: what is 97.45 * 1# =?

some_integer = 97.45 * 1# what does this notation mean? what will some_integer = ? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - VBA trigger macro on cell value change

This should be simple. When the value of a cell changes I want to trigger some VBA code. The cell (D3) is a ... way I can track when D3 changes? See Question&Answers more detail:os...

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

0 votes

943 views

1 answer

excel - CountifS + multiple criteria + distinct count

I'm looking for a formula calculating : distinct Count + multiple criteria Countifs() does it but do not includes ... excel file @ Excel file See Question&Answers more detail:os...

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

0 votes

900 views

1 answer

excel - item not found in "Find" vba

I'm looking for user ID #s from a list. However some users no longer exist. I've tried the test method, the ... and after the "cells.Find..." See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - How to Create a Pivot Table in VBA

I'm trying to create a Pivot table, but getting Invalid Procedure Call or Argument. ActiveWorkbook.PivotCaches. ... PivotTable frame just fine. See Question&Answers more detail:os...

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

0 votes

703 views

1 answer

excel - Cannot use an If-statement with multiple conditions (AND/OR) when looping through variant array?

Background: In working with some variant arrays to sort data to multiple locations based on criteria, I noticed that ... .Print dc.Count End Sub See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - VBA to set Zoom level on Sheets

I have a VBA that will set the zoom level based on the screen resolution. But its working only for ... Sub Workbook_Open() ScreenRes End Sub See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

excel - Optional Argument of COM Add-in vs Automation Add-in Written in C#

I am working on a library of COM Add-in and Excel Automation Add-in, whose core codes are written in C#. ... can help with this strange issue. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - VBA - Create ADODB.Recordset from the contents of a spreadsheet

I am working on an Excel application that queries a SQL database. The queries can take a long time to run ... Access VBA (using ADODB recordset) See Question&Answers more detail:os...

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

0 votes

906 views

1 answer

excel - How do I get my formula to always reference to the last sheet?

I currently have 2 worksheets in my excel file. The first sheet is known as the Summary page, which displays ... would be appreciated. Thanks! See Question&Answers more detail:os...

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

0 votes

862 views

1 answer

excel - Count matches between two columns

In Excel, I have two columns. One is a prediction, one is the result. I want to count how many times the ... be in the same row. Thanks. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - xlsxwriter not applying format to header row of dataframe - Python Pandas

I am trying to take a dataframe and create a spreadsheet from that dataframe using the xlsxwriter I am ... () display.FileLink(WorkBookName) See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - VBA Cell address of Max()

I have something like sdMax = WorksheetFunction.Max(Range("D2", Cells(emptyRow, 4))) to find the maximum ... location of this maximum number? See Question&Answers more detail:os...

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

0 votes

875 views

1 answer

excel - How do you extract a subarray from an array in a worksheet function?

Is there some way of getting an array in Excel of a smaller size than a starting array in a cell worksheet ... resultset to show all results. See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

excel - CreateObject randomly throws "A system shutdown has already been scheduled" error

I googled and SO'd, and nothing. My job revolves around making my co-workers lives easier. Currently, they ... Please help! Thank in advance. See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

excel - How to get address of adjacent cell?

I have the following vba code to find occurrences of "0" in a following column: For Each c In Range("B:B") If ... one where the "0" is found. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

excel - xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors

I have an xlsx file that I generate using SSIS. The data to this file is written through a data flow task ... Any help will be appreciated. TIA See Question&Answers more detail:os...

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

0 votes

848 views

1 answer

excel - Filter an array using a formula (without VBA)

Is it possible to filter an array using a single formula (without autofilter, VBA, or additional columns)? For ... rows that meet the condition. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - "While .. End While" doesn't work in VBA?

The code below is VBA for Excel. I am using the Visual Basic editor that comes with Excel 2007. Dim counter As ... doesn't. What has happened? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Does VBA Have a Ternary Operator?

I come from the beautiful world of Obj C, which is based on the C programming language, and I've fallen in ... , or enabling/disabling a button. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags