Recent questions tagged Excel

0 votes

986 views

1 answer

excel - VBA variable declaration okay on two lines but not when comma separated. Compiler bug?

I have the following variable declaration in a procedure which works fine. Dim table_rng As Range Dim attachments_rng ... . Thanks in advance. See Question&Answers more detail:os...

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

0 votes

841 views

1 answer

excel - Perform a FIND, within VBA, from the bottom of a range up

Is it possible for Find to start from the bottom of a range and work up? I would like my code to first find a ... If Loop End If End With Next D See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

excel - VBA: Copy paste without clipboard

Is there a way to do this as one line copy/paste without using the clipboard. copy one range ... ActiveCell.PasteSpecial Paste:=xlPasteValues See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Multiple csv files into a xlsx file but different sheets using powershell

I have 20 csv files. Each are unrelated. How do I combine them together into one xlsx file with 20 sheets, ... Workbook as XLSX. $xl.Quit() See Question&Answers more detail:os...

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

0 votes

750 views

1 answer

excel - Making all pivot tables on one sheet mimic each other in terms of rows expanding and collapsing

Alright, I'm new to VBA but I know this has to be possible. I spent a while coding android applications, but ... guys? Thanks a ton as always. 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: Acrobat Run time error 429; ActiveX component can't create object

I have the following codes to read in contents from a PDF file in Excel VBA: 'Note: A Reference to ... Adobe Reader File Preview Type Library See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Using ADODB to access opened xls file

Although I've been working with VBA for Excel for quite a long time, I've one problem I cannot solve by myself. I ... solved - hope I'm wrong :) 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 change series name in VBA

I have a series of charts I am creating using VBA (code below). I am having trouble changing the names of the ... " End With Next i End Sub See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Python Pandas read_excel doesn't recognize null cell

My excel sheet: A B 1 first second 2 3 4 x y 5 z j Python code: df = pd.read_excel (filename, ... example, for skiprows paramater, etc Thanks See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

excel - Copy all cells with certain value into another column skipping blanks

I have three columns, A, B and C: Column A contains names, NAME1, NAME2, etc. Column B contains only the ... ("C1:C30").RemoveDuplicates End Sub See Question&Answers more detail:os...

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

0 votes

986 views

1 answer

excel - Find and highlight a specific word in a range of cells

I want to find a specific word in a range of cells then highlight it in red. To do so I created this code but it ... = RGB(255, 0, 0) End Sub See Question&Answers more detail:os...

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

0 votes

869 views

1 answer

excel - How to disable the save as prompt?

If IsWorkbookOpen("CONTRACTCONTRACTLIST_Cement.xlsx") Then x = 0 Else Application.DisplayAlerts = False ActiveWorkbook.Close ... was still open. 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 multi-parameter function call Syntax Error

I'm trying to call a function in Excel VBA (2007), and am recieving a syntax error on the call. I have ... missing something stupid. What is it? See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

excel - Programmatically Install Add-In VBA

I'm looking to create a macro that'll install an add-in for the user to the excel ribbon. I'm upto: ... to be in the users default folder? See Question&Answers more detail:os...

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

0 votes

904 views

1 answer

excel - Fill multidimensional array

I was wondering how to fill a multi-dimensional array in Excel VBA. A 1d array can be filled as follows: ... for a multi-dimensional array? See Question&Answers more detail:os...

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

0 votes

893 views

1 answer

excel - Why does Worksheet.Copy not return a reference to the new workbook created

I have some code where wb is an existing multi-worksheet workbook. If I copy one of the sheets "Overview" a ... = wb.Sheets("Overview").Copy See Question&Answers more detail:os...

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

0 votes

768 views

1 answer

excel - Are these novelty ways [and possibly the best way?] to refer a dynamic cell in VBA?

We usually use the expressions: Cells(i, 1), Cells(i, "A"), or Range("A" & i) to refer a dynamic cell ... But it's only speculation on my part. See Question&Answers more detail:os...

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

0 votes

904 views

1 answer

excel - A good substitute for references/pointers in VBA?

Can you recommend me a good substitute for reference or pointer types in VBA? I have been struggling for long ... more difficult. Any ideas? See Question&Answers more detail:os...

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

0 votes

903 views

1 answer

excel - How to end infinite "change" loop in VBA

I have a problem with visual basic. I want to make a macro/function that will multiply a number I enter by 3 ... data in few cells at once. See Question&Answers more detail:os...

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

0 votes

812 views

1 answer

excel - "Non-contiguous" range specification in formula

[2018-08-01: See new material near bottom of post.] I just ran across a Q-n-A here that included an example ... with a concrete use for it yet. See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

excel - Add new lines in VBA email

I'm trying to send an email automatically through Excel, but the new line commands aren't working! I've tried < ... me know Regards as one line! See Question&Answers more detail:os...

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

0 votes

945 views

1 answer

excel - How do I only count visible rows when using the COUNTIFS function?

I've been using Excel's COUNTIFS function to count the number of rows in a table that meet certain criteria, E. ... ) How can I accomplish this? See Question&Answers more detail:os...

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

0 votes

972 views

1 answer

excel - Remove blank rows in table

I'm trying to run a macro that selects blank cells in a table column and deletes the entire row. ... Select Selection.EntireRow.Delete End Sub See Question&Answers more detail:os...

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

0 votes

894 views

1 answer

excel - How many times does each value appear in a column?

I have a column with time data like this: 17:27:31 17:27:32 17:27:32 17:27:33 17:27:33 17:27:34 17:27:34 ... 27:36 1 How can I do such a thing? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

excel - VBA - Get cursor position as cell address

I have the following code which works fine for retrieving the cursor position as pixels: Declare Function GetCursorPos ... . Is that possible? See Question&Answers more detail:os...

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

0 votes

886 views

1 answer

excel - Can MATCH function in an array formula to return multiple matches?

I tried to use the MATCH function in an array formula to return multiple matches (by default it only returns ... a complex, unreadable formula? See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

excel - How to use automatically update formula without dragging

I have a table in Sheet1 that looks like this **Sport** Basketball Basketball Basketball Volleyball Volleyball ... ease of understanding!!) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel formula - How to perform sum of previous cells of same column in PowerBI

I am trying to replicate Excel formula to PowerBI.Which is Is There any DAX to perform this calculation((1-0.2)*B2+0.2*C2). Thanks. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags