excel-vba

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

Solved September 23, 2013

2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why?

Good evening friends: I have in mind 2 ways for clearing a content in a defined range of cells of a VBA project (in…

thumb_up 8 trending_up 4

Solved August 28, 2013

I have text data in Excel worksheet in the cells B6:H14. Some rows will have 2 cells with contents while others have 4 and…

thumb_up 34 trending_up 2

Solved August 12, 2013

I am looking for a way to insert text into the background of a cell, so that I can still enter numbers on top…

thumb_up 6 trending_up 7

Solved August 8, 2013

I have code that resides on a page and references the content of the workbook. When executed from a different worksheet, I would like…

thumb_up 5 trending_up 6

Solved August 8, 2013

I want to allow a user to select a range that is likely to be in a different workbook. I have attempted to do…

thumb_up 18 trending_up 7

Solved August 5, 2013

I am developing a MS Excel 2013 tool with VBA which involves the use of QueryTables. One inconvenience I am experiencing is accessing existing…

thumb_up 5 trending_up 10

Solved July 30, 2013

I found a similar solution to this question in c#... See link below How to Select the whole excel sheet in Excel.Range object of…

thumb_up 15 trending_up 14

Solved July 14, 2013

Why does the following not work: Range(Cells(1,1)).Value = 3 Cells(1,1) should essentially be the same thing as using A1 right? (I realize that I…

thumb_up 9 trending_up 5

Solved June 27, 2013

I'd like to define a function in Visual Basic which computes income tax in a given bracket. The inputs should be the income, the…

thumb_up 7 trending_up 6

Solved June 5, 2013

I have a Report a part of it is hard to read and I would like to insert separating columns to make it easier…

thumb_up 8 trending_up 7