Recent questions tagged VBA

0 votes

766 views

1 answer

vba - Excel to remove duplicates one column at a time for many columns

I have an Excel workbook with many sheets(40+) which have many columns in each(30+). My goal is to ... selected when I created the macro. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

vba - Copy and Paste a set range in the next empty row

This should be simple but I am having a tough time.. I want to copy the cells A3 through E3, and paste them into ... ("A:A" & lastrow) End Sub See Question&Answers more detail:os...

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

0 votes

910 views

1 answer

vba - Deleting all columns except columns with certain headings

I am trying to format exported data and need to delete several columns. I want to keep columns with certain ... before in my life. Ever. See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

vba - Call Outlook procedure using VBScript

I have a procedure in Outlook that sends all the saved messages in Drafts folder. Below is the code: Public Sub ... have to tweak it a bit. See Question&Answers more detail:os...

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

0 votes

774 views

1 answer

vba - Alternating coloring groups of rows in Excel

I have an Excel Spreadsheet like this id | data for id | more data for id id | data for id id | data ... with a macro or some VBA code Thanks See Question&Answers more detail:os...

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

0 votes

820 views

1 answer

vba - Alternating coloring groups of rows in Excel

I have an Excel Spreadsheet like this id | data for id | more data for id id | data for id id | data ... with a macro or some VBA code Thanks See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

vba - Alternating coloring groups of rows in Excel

I have an Excel Spreadsheet like this id | data for id | more data for id id | data for id id | data ... with a macro or some VBA code Thanks See Question&Answers more detail:os...

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

0 votes

726 views

1 answer

vba - Excel to remove duplicates one column at a time for many columns

I have an Excel workbook with many sheets(40+) which have many columns in each(30+). My goal is to ... selected when I created the macro. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Copy and Paste a set range in the next empty row

This should be simple but I am having a tough time.. I want to copy the cells A3 through E3, and paste them into ... ("A:A" & lastrow) End Sub See Question&Answers more detail:os...

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

0 votes

967 views

1 answer

vba - Deleting all columns except columns with certain headings

I am trying to format exported data and need to delete several columns. I want to keep columns with certain ... before in my life. Ever. See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

vba - Call Outlook procedure using VBScript

I have a procedure in Outlook that sends all the saved messages in Drafts folder. Below is the code: Public Sub ... have to tweak it a bit. See Question&Answers more detail:os...

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

0 votes

885 views

1 answer

vba - Alternating coloring groups of rows in Excel

I have an Excel Spreadsheet like this id | data for id | more data for id id | data for id id | data ... with a macro or some VBA code Thanks See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - How to loop through all Tables in an MS Access DB

I need to read the properties of over 100 tables in an Access 2003 database and write those details - table name ... have well over 100 fields. See Question&Answers more detail:os...

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

0 votes

963 views

1 answer

vba - How to check whether a variant array is unallocated?

Dim Result() As Variant In my watch window, this appears as Expression | Value | Type Result | | Variant/ ... and the second does not exist. See Question&Answers more detail:os...

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

0 votes

946 views

1 answer

vba - Declare a Workbook as a Global variable

I am starting to write a code that will become applicable to multiple workbooks, but always uses the same ... "Sheet1").UsedRange.Rows.Count See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

vba - Modify an embedded Connection String in microsoft excel macro

I have an Excel document that has a macro which when run will modify a CommandText of that connection to pass in ... that does not work. Thanks. See Question&Answers more detail:os...

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

0 votes

849 views

1 answer

vba - ActiveSheet.UsedRange.Columns.Count - 8 what does it mean?

what does ActiveSheet.UsedRange.Columns.Count - 8 mean in vba? How does vba know the usedRange? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Setting selection to Nothing when programming Excel

When I create a graph after using range.copy and range.paste it leaves the paste range selected, and then when ... an extra series to the plot. See Question&Answers more detail:os...

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

0 votes

814 views

1 answer

vba - Tricks for generating SQL statements in Excel

Do you have any tricks for generating SQL statements, mainly INSERTs, in Excel for various data import scenarios? I'm really ... '" & D2 & "')" See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

vba - For Each loop: How to adjust code to move files in one run rather than multiple

I am using the below code to archive emails that have been marked completed. It is supposed to check all emails ... End If End Select End Sub See Question&Answers more detail:os...

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

0 votes

884 views

1 answer

vba - How can I compare all the titles of all RSS feeds and delete duplicates?

I'm wondering if there is a way to compare ALL TITLES in ALL RSS FEEDS and delete the duplicates. I read ... Nothing End Sub Thanks to all!! See Question&Answers more detail:os...

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

0 votes

897 views

1 answer

vba - Move items to a specified subfolder inside Outlook based on ReceivedTime

I'm trying to move Outlook Items, However the code runs with no error messages but no emails are moved. This ... End If Next aItem End Sub See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

vba - Variable not being stored in the code when sheet changes

I'm quite new to coding and have encountered a probably very trivial issue. When I run the code line by ... be much appreciated. Thanks all! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Set Focus to Internet Explorer Object in Visual Basic

Does anybody know how to set focus onto an IE object with Visual Basic? I've tried myieobject.SetFocus, ... compiler errors with this statement. See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

vba - Excel Macro - Comma Separated Cells to Rows Preserve/Aggregate Column

I had a similar question answered Here There is a slight twist to the scenario and hoping the macro can be ... fromRow).Value Wend End Sub See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

vba - How to wrap Excel cursor to keep it within a specific range

In Excel, I have three columns: column1, column2, column3 I am entering data into excel using a barcode scanner ... is detected in column 3? See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

vba - Create data validation list when some of the values have commas?

I am creating a data validation list using the following method: sDataValidationList = sDataValidationList & wksCalculation. ... commas in them? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Dictionary object adding items before .add() is called

I am using a dictionary object from the MS Scripting Runtime library to store a series of arrays and perform ... even on the first iteration. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags