Recent questions tagged Excel

0 votes

1.0k views

1 answer

excel - Searching rows for two entries and returning the successful results (adapting existing code)

I am currently using this code in Excel to find and return, via an array, the results of a search but I ... above. Any help is much appreciated. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Move data from multiple columns into single row

This formatting issue is confusing me. I'm not an Excel king and would greatly appreciate the solution to my ... seen in the before column). See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Convert String to Date VBA

I have a String with a date and a time in this format "DD.MM.YYYY HH:mm" which I want to convert to a date ... .2015 01:01" Data2 = CDate(Data1) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - SUMIFS with multiple criteria variable

I just discovered here that I can use SUMIFS with multiple criterias, which is really cool. But there is any way to ... {A1,"blue"})) Thank you See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Conditional formatting: using row() inside indirect() inside and() doesn't work. What am I doing wrong?

Say I have set a value of 55 on cell B2. If it's value is 55, the cell's background color should be green ... ? And how do I solve this problem? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Run-time error '1004' when using fully qualified cells in range object

I am trying to copy values from one workbook and paste them into another using the cells property of the ... the destination sheet as expected. 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: Set variable to "Empty" or "Missing"? Handling multiple optional arguments?

Is it possible, or desirable, to set objects/data to an "Empty" or "Missing" variant? I want to be able to ... eval(funcs) output = func1(*args) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - VBA Sorting of Data

The problem i run into is that sometimes entire headers and data values are missing in the dataset and therefore ... four lines seem to fail. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - CSV Exporting: Preserving leading zeros

I'm working on a .NET application which exports CSV files to open in Excel and I'm having a problem ... file to prevent this from happening. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - If logic where either of two conditions make it true

I am trying to delete a row if cells in column V is not equal to F or V. This code deletes everything. For i ... "V" Then Rows(i).Delete 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 - OptionButton index issue

I have five option button(Form control) on first five cell of each row. The option button are linked to sixth ... ) Thanks for looking into it. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - What does bb or bbbb represent in an EN-US TEXT function or Custom Number format mask?

On a EN-US regional system, what does B or b represent in a format mask? While it does nothing in VBA's Format ... Office on 64 bit EN-CA OS) See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - How do I convert a given number into time format HH:MM:SS in VBA?

I received a list of numbers in Custom format (Type: 000000) that represent military time. It always contain 6 ... use military, 24-hr clock. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - workaround named range character limit

I'm building a graph, where the series are named ranges. It all works fine as I have a dropbox, where I ... this is where the problems kick in. 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 can fill I cells A1:A5 with a color using C#?

I have the following code: Excel.Range chartRange; chartRange = xlWorkSheet.get_Range("A3", "R3"); I want to ... fill these cells with a color? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Change Worksheet When a Cell Value and a Checkbox Change

I have a Workbook with multiple Sheets. I have a menu page (Worksheet) with multiple user choices (Enter a new ... sh).Select End If End Sub See Question&Answers more detail:os...

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

0 votes

953 views

1 answer

excel - How do I sum data based on a PART of the headers name?

Say I have columns /670 - White | /650 - black | /680 - Red | /800 - Whitest These have data in ... it doesn't support multiple rows/dragging. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Stack multiple columns into two colums in pairs of two

I have columns A:ALC filled with data, and there is a varied number of rows for each column. If possible, I ... 12 2599 G650 ROW 13 2599 K1600 See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

excel - org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException in POI API after an .xls file is updated with Libre Office

I am reading an Excel using POI api, I use the following code to read the excel file. public class ... ... 53 common frames omitted See Question&Answers more detail:os...

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

0 votes

979 views

1 answer

excel - Edit Word document embedded in a workbook and save as copy

I have made a Word template and inserted it to Excel as an object. I am opening it with the code and inputting ... ).Value & ".docx" End Sub See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

excel - Copy multiple ranges with VBA

I am trying to copy multiple ranges using Excel VBA. I understand that in order to select multiple ranges, syntax ... is a syntax issue..? See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

excel - Sum of 3 numbers in same cell using a reference formula as well

IN B1 I have: 3,4,5 IN B2 I have the sum of these numbers 12 I would like to add these together ... make sure these numbers match. Thank you See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Is there a Mac/PC variant of Application.GetOpenFilename?

Is there a universal OS variant of this? I am looking to have this code work on a Mac and PC, but this seems ... , "Please selec text file...") 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 insert a break line in 'mshta.exe' pop up (VBA macro)?

I need a msgbox that does not stop the macro. Is there a way to insert a break line, same as 'vbNewLine' ... I want it to display: Hello World See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - Writing and modifying an existing workbook using Python

I am new to Python and working on a project that I could use some help on. So I am trying to modify an existing ... sht.range('M6').value = df1 See Question&Answers more detail:os...

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

0 votes

957 views

1 answer

excel - VBA: Extract Top 'x' Entries from each category

By way of simplified example, say you have the following dataset: A B C Name Group Amount Dave A 2 Mike B ... , cleaner way of doing 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 - Run Macro When ComboBox is Clicked

I need help with figuring out how to make a macro run when I click the ComboBox. For example, the ... Application.ScreenUpdating = True End Sub See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

excel - Updating an array stored in a VBA dictionary

I'm creating a data structure that uses nested dictionaries and a list at the lowest level. Here's a sample of my ... on what I'm doing wrong? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags