excel-vba

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

Solved June 14, 2010

How to Lock the data in a cell in excel using vba

I want to stop others from editing the cell contents in my excel sheet using VBA. Is it possible to do this?

thumb_up 18 trending_up 9

Solved June 10, 2010

I have an array like this: Dim aFirstArray() As Variant How do I clear the entire array? What about a collection?

thumb_up 58 trending_up 29

Solved June 4, 2010

I have multiple lists that are in separate columns in excel. What I need to do is combine these columns of data into one…

thumb_up 11 trending_up 5

Solved June 1, 2010

I need to find out the first cell and the last cell of a vertically merged cell.. Let's say I merge Cells B2 down…

thumb_up 11 trending_up 7

Solved January 2, 2010

I'm trying to write a macro that copies the content of column 1 from sheet 1 to column 2 on sheet 2. This is…

thumb_up 16 trending_up 6

Solved December 15, 2009

I have an image in cell (3,1) and would like to move the image into cell (1,1). I have this code: ActiveSheet.Cells(1, 1).Value =…

thumb_up 7 trending_up 8

Solved November 29, 2009

Can you create an Excel VBA function that returns an array in the same manner as LINEST does, for example? I would to create…

thumb_up 8 trending_up 5

Solved November 21, 2009

Is there a way to force garbage collection in VBA/Excel 2000? This question refers to the Macro language in Excel. Not using VB .NET…

thumb_up 9 trending_up 4

Solved October 12, 2009

Given Select Case cmd case "ONE": MsgBox "one" case "TWO": MsgBox "two" case "THREE": MsgBox "three" End select My requirement is if cmd =…

thumb_up 12 trending_up 6

Solved October 7, 2009

The following VBA code (Excel 2007) is failing with Error 1004, "Autofill Method of Range Class Failed.". Can anyone tell me how to fix…

thumb_up 16 trending_up 6