Recent questions tagged Excel

0 votes

997 views

1 answer

excel - How to find the difference between dates in VBA

I am trying to find out the difference between the system date and the date stored in the worksheet. If the difference ... be a past date, too. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Get Selected value of a Combobox

I have a thousands of cells in an Excel worksheet which are ComboBoxes. The user will select one at ... the ComboxBoxes has been selected? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - How to avoid using .Select, .Activate, ActiveSheet,ActiveCell in my specific vba code?

I have this code that obviously use Select, .Activate,...and I understand it's not a good practice in addition the ... 15 + i + End If... See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Move content from 1 column to 3 columns

I have long file with this content: John Doe1 Street Foo 35 New York Mary Johnson Street Foo 49 Los Angeles ... possible? Excel 2007/Windows 7 See Question&Answers more detail:os...

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

0 votes

988 views

1 answer

excel - Error in NVL function,is there any equivalent function like NVL

The below code is written VBScript.but the line Set rs = cmd.Execute throwing an error saying that NVL is not ... (1,25).Value=cmd.CommandText See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Reverse one of the array's order in an SUMPRODUCT

I am in the process of trying to calculate a couple of values The first value I am trying to calculate is this ... can be done in a SUMPRODCUT. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - Numbering/sequencing sets of same column values

How to do numbering/sequencing for sets of same column values? For example: Col1 Col2 Andy 1 Chad 1 Bill 1 Andy 2 Bill ... 2, 3 and 4 and so on. 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 do I apply data filter to only the table range and not the whole row?

I have got two adjacent tables. When I apply data filter on first table, it filters the whole row hiding rows ... to only the first table range? See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

excel - VBA to change Pivot Filter in OLAP cube to a range

I have a pivot table that pulls data from an OLAP cube, and I'd like to create a macro to filter a ... by entering 15 in a specified field. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - If Cell In Column Partially contains text in another Column

I have been looking through all different sources and cannot find the exact answer to this. Was hoping someone ... (substring,text)) Thanks! See Question&Answers more detail:os...

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

0 votes

938 views

1 answer

excel - Skip over function error and continue with next check (VLOOKUP)

I am running a basic VLOOKUP to get an employees email address. However, when the lookup value enters an ... be the first empty column? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

excel - How to list properties of a chart object in VBA?

I want to clone(using VBA) some charts and be able to change them for that I need to know what they ... an object dump in other languages? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Trying to capture key press while sub running ( for snake game ) VBA

i'm a but stuck with a snake game I am trying to make, it seems that at the moment the "HEAD" of the ... True Call movecheck 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 2010 VBA throws "can't execute code in break mode" while stepping

I have just moved to excel 2010, have discovered surprising behaviour when stepping through code. When stepping ... macro. thanks in advance 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 code to loop through every folder and subfolder in Outlook

I am trying to get the following code to look through all folders and subfolders in Outlook under Inbox and ... under Ontario and Cheap clothes. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel formula - Dynamic date range based a range of cells

I have a range of cells where US federal holidays are stored. The formula below then calculates a date 21 ... =WORKDAY(A305,21,$O$290:$O$310) See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Find column name based on search criteria

I have the following Excel spreadsheet: A B C D E F 1 MFC2 MFC1 QFC Search Criteria: CW14 2 CW11 Column ... change to get the desried result? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Deactivate msgbox in a sub VBA

Sub prelim() MsgboX "Hello World" End Sub Sub Main() Call prelim End Sub In the above code Sub prelim can't be ... get popped out. How to do it? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - insert check box to a particular cell through vba macro

I would like to insert the check box in particular cell through macro. For example: On click of a command ... .Display3DShading = False End With See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

excel - Return max index value in vlookup

I'm trying to pair a vlookup with a max function. For some reason it only returns #ref every time I try to ... use max on the returned index. 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 converting csv Files in a folder to xlsx Files

I have this code. This code converts to xlsm files. I want to convert to xlsx files. How? I tried by changing ... False fname = Dir Loop 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 - Batch Convert TXT to XLS Using VBA

I am trying to convert a directory full of .txt files to .xls using VBA. I am using the following ... would be greatly appreciated - 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 - Vba: display decimals with point and not coma

I would like to have all numbers in a macro displayed with point and not coma For Instance This display "0,03" but I ... ",", ".")) Thank you! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

excel - Add in installed and referenced

I want to check if addin is installed and is referenced. The below code checks for add in is installed or not. ... = True End If End Function 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 find the font color of a string

I am new to VBA..I am writing a macro for some file comparison..My requirement is if a string has red ... complete this task Thanks in advance. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

excel - Only copy visible range in VBA?

I'm running into an issue where I'm unable to copy only visible cells to a new sheet. I'm able to ... (xlCellTypeVisible).Value End With 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 - Embed OLEobject based on cell

I want to embed an OLEObject (text file) in Excel, with the filename being derived from a particular cell. I can ... left End If 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 - Expand Start Date to End Date with Series of EOMONTHs

I have a data table containing ids with a start date and end date associated with both. RowNo AcNo StartDate ... or code would be welcome. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags