Recent questions tagged Excel

0 votes

669 views

1 answer

excel - Convert string to int if string is a number

I need to convert a string, obtained from excel, in VBA to an interger. To do so I'm using CInt() which works ... integer and set to 0 if not? See Question&Answers more detail:os...

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

0 votes

781 views

1 answer

excel - Delete entire row if cell contains the string X

I am new to VBA and I am trying to come up with a way to delete all rows (and shift cells up, if ... any suggestions. Many thanks in advance! See Question&Answers more detail:os...

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

0 votes

663 views

1 answer

excel - Iterate over VBA Dictionaries?

I'm using the Dictionary class in the MS Runtime Scripting library to store where labels are going to go for a ... Value = dict(key) Next key See Question&Answers more detail:os...

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

0 votes

679 views

1 answer

excel - Copy VBA code from a Sheet in one workbook to another?

I've been using the lines below to compy VBA modules from one workbook to another and I don't know if ... sheet from one workbook to another? See Question&Answers more detail:os...

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

0 votes

757 views

1 answer

excel - How to have vba execute every 10 minutes?

I need to have my macro executed every 10 minutes . This allows it to work in 10 minutes sub my_Procedure ( ... macro execute every 10 minutes ? See Question&Answers more detail:os...

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

0 votes

650 views

1 answer

excel - Use string value from a cell to access worksheet of same name

I have 2 worksheets: Summary and SERVER-ONE. In cell A5 on the Summary worksheet, I have added the value SERVER- ... : ='A5'!G7 Any suggestions? See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

excel - How do I express "if value is not empty" in the VBA language?

How do I express the condition "if value is not empty" in the VBA language? Is it something like this? " ... empty then..." Edit/Delete Message See Question&Answers more detail:os...

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

0 votes

581 views

1 answer

excel vba: Special Types - Functions as Arguments of Functions

There is no special type for functions in VBA. It is hard for me to see how to add functions as arguments ... one call to a specific function. See Question&Answers more detail:os...

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

0 votes

548 views

1 answer

excel - How should I make my VBA code compatible with 64-bit Windows?

I have a VBA application developed in Excel 2007, and it contains the following code to allow access to the ... 2007 is not an issue. See Question&Answers more detail:os...

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

0 votes

693 views

1 answer

excel - Copy every nth line from one sheet to another

I have an Excel spreadsheet with 1 column, 700 rows. I care about every seventh line. I don't want to ... how to do this elegantly/efficiently? See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

excel - Importing a big xlsx file into R?

I'm wondering if anyone knows of a way to import data from a "big" xlsx file (~20Mb). I tried to use ... works. Does anyone have an idea? See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

excel - If Cell Contains This or That Paste onto Another Sheet

I have 2 sheets in my workbook SheetJS and Sheet1. I have this code that partially matches cells in each row ... Any tips will help thank you! See Question&Answers more detail:os...

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

0 votes

642 views

1 answer

excel - Generate 5000 records in 2 columns of random number that being unique

How I can generate 5000 records in 2 columns of random numbers between 1 and 100 that being unique. For example: A B - ... 18 . . . . . . thanks See Question&Answers more detail:os...

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

0 votes

628 views

1 answer

excel - How can I get worksheet code name to activate a specific worksheet?

I have a worksheet with the "tab" name of "Rpt_Group". I also renamed its code name to shData. When I ... does not work: WBA.shData.Activate See Question&Answers more detail:os...

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

0 votes

657 views

1 answer

excel - Filtering pivot table with vba

I have a chart that picks the info from a pivot table that I have with daily data. I am trying to create ... 't work! Can someone help me? See Question&Answers more detail:os...

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

0 votes

553 views

1 answer

excel - Excel2011: Vlookup and Combine

I'm having some difficulty combining several functions to do what I want in a 70000+ line excel file. ANY tips or ... using the right one(s). See Question&Answers more detail:os...

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

0 votes

668 views

1 answer

excel - How to create all possible pair combinations without duplicates in Google Sheets?

How to perform iteration over excel/google sheets cells to get pairwise combinations? "string1" "string2" " ... possible in google sheets? See Question&Answers more detail:os...

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

0 votes

660 views

1 answer

excel - Hiding rows based on cell value is very slow

I have working code to hide/unhide rows depending on the corresponding cell value. This is a list of materials and ... = False Next cell End Sub See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

excel - Convert an Array Formula's Text Results into a Usable Format

When the results of an Array Formula are numbers, I find it generally easy to find an appropriate method to collapse the ... (C1,C2,C3...C10). See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

excel vlookup with multiple results

I am trying to use a vlookup or similar function to search a worksheet, match account numbers, then return a ... ie. "Grain Oilseed Hay" See Question&Answers more detail:os...

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

0 votes

602 views

1 answer

excel - Lookup a value that matches a key in one column then apply that as a key to return a value from a third column

I have values in columns G and N that have the same values, but not in the same order, so if column G and ... Items1 45 1 Apple 45 1 Apple See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

excel - Not able to create array from 1 cell range in VBA

I have code that reads ranges and converts them to arrays for processing. It unfortunately fails when the range ... range has only one element? See Question&Answers more detail:os...

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

0 votes

619 views

1 answer

excel - VBA: How to find search value from Sheet "DMR" and then from found search value row copy cell at column A and cell at Column D into Sheet "Search"

This is my first time asking for help on any VBA programming sites. I am very new to VBA programming (had ... much for your patience! Veronica See Question&Answers more detail:os...

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

0 votes

691 views

1 answer

excel - VBA Removing duplicates values in an array including the same value

There is a way to remove all duplicates in array with VBA, also the first value. Just keeping the not Duplicated ... 'pedro','maria','jesus'] See Question&Answers more detail:os...

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

0 votes

738 views

1 answer

excel - VLOOKUP vs INDEX

In Excel, I'm trying to do the following: Where sheet1 column 1 = sheet2 column 2, return the value in sheet2 ... )) This doesn't work either. See Question&Answers more detail:os...

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

0 votes

586 views

1 answer

excel - Identify cells in red

The title may be typically simple, but I did not get a solution yet even after researching over several forums on ... Could you please help me? See Question&Answers more detail:os...

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

0 votes

595 views

1 answer

excel - Previously active cell

For the code I am writing I monitor the changes in certain cell ranges to run functions and private ... ActiveCell MsgBox xfrLastCell End Sub See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

excel - Find an email with subject starting with specific text

I am trying to find an email, by subject starting with specific text, to then download an attachment from that email. I ... = j + 1 Loop End sub See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags