excel-vba

136 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.

Solved October 31, 2012

Excel VBA for selecting an entire column starting from a specific cell

How do I select the entire column after a specific cell? For example, I would like to select the entire column after C24 so…

thumb_up 7 trending_up 4

Solved October 26, 2012

I want to count number of rows in Sheet1, from the Sheet2 code module. In the sheet1 code module, the following code works fine…

thumb_up 7 trending_up 4

Solved October 24, 2012

I am trying to run a single macro which performs functions on multiple worksheets. Let's say I have assigned the macro button on worksheet…

thumb_up 7 trending_up 7

Solved October 20, 2012

I'm trying to run a macro that selects blank cells in a table column and deletes the entire row. The script below does everything…

thumb_up 6 trending_up 6

Solved October 16, 2012

I would like to fill an array in VBA with the row numbers of only rows which meet a certain criteria. I would like…

thumb_up 11 trending_up 11

Solved September 24, 2012

I'm trying to get as close to function pointers / abstract classes as I can in VBA. I have a class called VerificationManager and…

thumb_up 5 trending_up 6

Solved August 29, 2012

I need a way to count numbers and letters separately within one cell. For example, if a cell contains 1234567ABC I need to be…

thumb_up 5 trending_up 6

Solved August 16, 2012

I have recently started writing some Macro's in Excel. I have a protected worksheet, and a few buttons that allow the user to add/remove…

thumb_up 11 trending_up 7

Solved August 13, 2012

I need to find if a cell is visible on the screen. By visible, I don't mean hidden. I am specifically trying to find…

thumb_up 11 trending_up 8

Solved August 2, 2012

I'm trying to download and then open an Excel spreadsheet attachment in an Outlook email using VBA in Excel. How can I: Download the…

thumb_up 43 trending_up 16