Recent questions tagged VBA

0 votes

585 views

1 answer

vba - How to add parameters to an external data query in Excel which can't be displayed graphically?

I often use MS Excel's Get External Data to create simple reports - running queries against databases and ... t be displayed graphically"? See Question&Answers more detail:os...

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

0 votes

753 views

1 answer

vba - Loop through each row of a range in Excel

This is one of those things that I'm sure there's a built-in function for (and I may well have been ... through a one-dimensional range... See Question&Answers more detail:os...

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

0 votes

748 views

1 answer

vba - excel hyperlink to nothing

I've got a lot of hyperlinks and I want to assign a macros to each of them and Worksheet_FollowHyperlink captures ... 's cell. Thanks in advance See Question&Answers more detail:os...

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

0 votes

698 views

1 answer

vba - Delete cells in an Excel column when rows = 0

I am trying to delete all cells =0 in a column in my spreadsheet and "summon" the values which don't to ... cells and then shift cells up. See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

vba - Fastest way to delete rows which cannot be grabbed with SpecialCells

Based on another question on this site I started wondering about the fastest way to delete all rows with a certain ... fastest way to do that? See Question&Answers more detail:os...

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

0 votes

739 views

1 answer

vba - Change color of certain characters in a cell

I have the sentence "I would like 50 of those, please" in cell A1. I want to make any numeric ... Any help would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

vba - What does ReDim Preserve do?

I am looking at someone else's vba excel code. they are doing ReDim Preserve dataMatrix(7, i) in both loops. ... Preserve dataMatrix(7, i) Loop See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

vba - Should I turn .CutCopyMode back on before exiting my sub procedure?

In order to optimize my code, I turn off several Application Object member properties; one in particular being the . ... ??? End With End Sub See Question&Answers more detail:os...

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

0 votes

980 views

1 answer

vba - TextJoin UDF For Excel 2013

I am trying to utilize a UDF version of TextJoin since I am using Excel 2013 - but this function is not properly ... I get an error of #VALUE! See Question&Answers more detail:os...

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

0 votes

867 views

1 answer

vba - Count unique values in Excel

I need to count unique values in range (C2:C2080) in excel. Googled formula: =SUM(IF(FREQUENCY(MATCH(C2:C2080;C2: ... 15).Value = count End Sub See Question&Answers more detail:os...

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

0 votes

954 views

1 answer

vba - Excel's fullname property with OneDrive

If I want to use the open Workbook object to get the fullname of an Excel file after saving it, but that file has ... shows as "https://..." See Question&Answers more detail:os...

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

0 votes

824 views

1 answer

vba - One-dimensional array from Excel Range

I'm presently populating my array Securities with the following code: Option Base 1 Securities = Array(Worksheets(3). ... a with each loop). See Question&Answers more detail:os...

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

0 votes

930 views

1 answer

vba - How to "flatten" or "collapse" a 2D Excel table into 1D?

I have a two dimensional table with countries and years in Excel. eg. 1961 1962 1963 1964 USA a x g y France ... how I can do this using Excel? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Search as you type with MS Access Combobox

I would like to create a simple search-as-you-type combobox in Microsoft Access as shown in the image below. ... search-as-you-type combobox? See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

vba - How to copy a chart from Excel to PowerPoint?

Is there any way I could copy a chart from an excel spreadsheet to a powerpoint, preserving the original ... an external excel file.) See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

vba - Range() vs Cells() vs Range.Cells()

I know that the Range() and Cells() properties are equivalent methods of accessing cells on a worksheet. ... the advantage of the former? See Question&Answers more detail:os...

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

0 votes

687 views

1 answer

vba - MS Access prepared statements

Is it possible to execute a prepared statement in MS Access on a local table in VBA like this: UPDATE part SET ... If so how is it done? See Question&Answers more detail:os...

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

0 votes

742 views

1 answer

vba - Is there a way to import data from .csv to active excel sheet?

I have a csv file always named the same, called SO2PO.csv. It has data that I import into an excell sheet ... in placed into a specific folder? See Question&Answers more detail:os...

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

0 votes

741 views

1 answer

vba - How to highlight a cell using the hex color value within the cell?

I have a spreadsheet of symbols and matching hex colors. I want to fill the cell itself (or the one next to ... achieve the result I would like? See Question&Answers more detail:os...

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

0 votes

914 views

1 answer

vba - Getting the headings from a Word document

How do I get a list of all the headings in a word document by using VBA? See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

vba - Macro to export MS Word tables to Excel sheets

I have a word document with many tables. Does anyone know how to write a macro to export such tables to different Excel sheets? See Question&Answers more detail:os...

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

0 votes

790 views

1 answer

vba - Refreshing all the pivot tables in my excel workbook with a macro

I have a workbook with 20 different pivot tables. Is there any easy way to find all the pivot tables and refresh them in VBA? See Question&Answers more detail:os...

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

0 votes

631 views

1 answer

vba - Photo alignment in Excel after rotation in excel

I've got a macro where I would like to resize a photo and put it in a cell of my spreadsheet in Excel. I have the ... imgur.com/M1hYX.png [3]: https://i.stack.imgur.com/TChMV.png...

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

Categories

Just Browsing Browsing

Most popular tags