This ought to be simple, but I can't find any working examples. I want to test that I'm on the right sheet, and if not exit the procedure. I've found the ActiveSheet property, but can't figure out how to use it. I'd like something like:
If ActiveSheet.Name <> "Sheet1" Then Exit ...

I'm trying to use Class modules.
One of the advantages of using these nodules seems to be the ability
to do more on-the-fly error trapping when setting properties and
running methods.

I am trying to manipulate a named range ("CompetitorShareOption") of 1 column
x 6 rows in VBA.  I have declared the array (Dim CompetitorOptionsArray as
Range), and am bringing it into VBA with the line:
Set CompetitorOptionsArray = Range("CompetitorShareOption")

I have a spreadsheet of items and their sizes. Each item has 7 sizes. I need
to add 6 rows under each item and copy the data from the from the first row.
There are 150 items in the spreadsheet and I basically need to create a macro
to copy each item 6 times right underneath the ...

I have a cell formula that retrieves data from three cells and puts
them together like so:
=A1&CHAR(10)&B1&CHAR(10)&C1
The CHAR(10) is a some kind of line feed to give me the stacked data

i have an array formula that i'd like to evaluate in code and store it in a
variable instead of creating the array formula.
is it possible?
here is what the formula would look like if i wrote it to a cell:

I want tp close tempdata if it is open
If ActiveWorkbook = "Tempdata.xls" Then
       ActiveWorkbook.Close
End If

Hello, I wanted to write a routine in C# that converts a Excel column number
to column letter and vice versa. Any ideas?

I have a macro which deletes a set of rows, but once the delete is done, I
need the curser to shift right by i cell. Problem is when you delete rows you
do not have just one active cell selected.
2. is there any way to ensure the macro does not run if an entire row (or

This is regarding the development of an add-in to create Excel 2007 custom
ribbon ui. I have written the required xml and vba callbacks and every thing
is working fine. The problem is that, the custom menus do not appear under
the custom tab when there is no opened workbook. When ...

It has been a few years since I wrote much code for Excel, so I am at a loss
with something that, IIRC, is fairly simple.
I added some radio button ActiveX components to my spreadsheet, and
double-clicked on them to open the editor and put some simple code there.  I

Having difficulty and full disclosure - ** VB Newbie **
I would like to hide rows e.g., 20-25, 51 and 80-90 if the value in cell L15
= "Additional" and expose these same rows if the value in cell L15 = "Final"
Cell L15 is set up using Data | Validation | List | Additional,Final

I have a stored query in Access I use to export a "flattened" version of my
highly normalized database. It's exported to excel.
I have recently taught my users to use MS Query from excel, targeting the
stored "flattened" query. Unfortunately, due to the prevelance of nulls in

I have a userform that uses a textbox (tbExistingProjectNumber) to find an
existing project number and replace it with a new project number from another
textbox on the same userform (tbChangeProjectNumberTo).  My problem is that
if the value in tbExistingProjectNumber starts with ...

A while back I recorded a macro to select a worksheet from one workbook, and
then place that into another workbook.
I'd like to take this to the next step where I choose the workbook.
I have the following code, and get a " subscript out of range" error.