Questions tagged [vba]

Visual Basic for Applications (VBA) is an event-driven programming language first introduced by Microsoft in 1993 to give Excel 5.0 a more robust object-oriented language for writing macros and automating the use of Excel. It is now used for the entire Office suite and over 200 non-Office hosts.

Filter by
Sorted by
Tagged with
-1
votes
2answers
173 views

Building a new Excel sheet from queries on existing sheets

This code runs a number of queries on various sheets, copies the table values to new sheets for manipulation such as sorting and summing, and finally builds a template sheet from the newly manipulated ...
-1
votes
1answer
55 views

Is it possible to make this macro faster? Copy and paste when condition is met [closed]

I have a problem with macro running too slow and I guess it is just because of lack of my knowledge. I have a macro that is copying data from "database" and paste it to another sheet. Macro ...
-1
votes
1answer
106 views

Excel VBA - How to optimize this code with a lot of inserts

Can you please suggest how below code can be optimize? It takes around 2 minutes in Windows and 4 plus minutes in Excel 2016 for Mac. I think I will have to use write once method, accumulating the ...
-1
votes
1answer
47 views

How to return cell values of a non-sequential set of cells from multiple closed spreadsheets? Code condensing/simplification [closed]

The code below does what I need it too but it is ugly and clunky. If I could set the list of cells I want to retreive data from as an array that is declared somewhere, then I could loop through that ...
-1
votes
1answer
900 views

Table criteria filter

My tables retrieve entries from the database through a dropdown list so they can have 1 to 500 entries, therefore auto-filter to remove blanks is inevitable. I have tables across many sheets, however ...
-3
votes
1answer
88 views

Calculate quantities in a userform [closed]

This is used on an Excel order form to calculate quantities in a userform for variables based on various criteria on the worksheet. It's too much code for a single Sub, but I'm not sure how I can make ...
-4
votes
1answer
178 views

Excel Manipulation in Single Procedure part 2

So again I modified my last posted code as other fellow friends said me. So please review and let me know what more modifications and optimisation I can do in This code now. Previous Post Spreadsheet ...

1
21 22 23 24
25