The following code sends the active sheet to a group of individuals
automatically via e-mail. . Two of the individuals will always receive
the e-mail, the third would depend upon which individual requested the
data, the third individuals name is called from a lookup table and the

I am trying to write out the 2 dimension of my arry into a range in
excel but not having luck.  I can write out the first dimension with
'Range("L5:L2000") = aSMA' which I assume is dimension '0', but how do
i get dimension '1'?

I would like to put:
HLRange.Formula = "=Hyperlink('file:\\Server1\test.pdf')"
in code but I get a run time error-1004 message, can someone help with the
formatting on this.

I am creating a monthly forecast sheet. There are columns P to Z listed
as forecast columns with the MOnths  ( Jan to Dec).
Cell A1 in the sheet is the currrent month cell which changes every
month.

I have a named range of cells D19:D1000 (EntryAreaProposal). There i
data above this range and below this range. I want to find the las
used row within this range and of course if I use something like:
LastRow = wks2.Cells(Rows.Count, "D").End(xlUp).Row

Friends,
I have written VBA code that loops through 150 workbooks and performs
various tasks on each workbook. One task I need to perform is deleting one
sheet in each workbook.

I have been using Excel for many years, but only out of box kind of way,
never has dabbed the deep water of VBA. Now life has come to a stage that I
realize it maybe do me good to know some VBA techniques. I looked around and
there are so many books on VBA availalbe , I am just ...

I have some command buttons on a userform.  I want each of these command
buttons to take me to a different worksheet in the workbook.  I am so new to
VBA and don't really understand it at all.  I have the command button on the
form, I double click it to bring up the code window ...

I am new to vba and want to write a function that takes a range of
cells as the argument.  In VBA I want to be able to mostly access the
value in the first cell, and the value in the last cell.  Do I want to
use the 'range' type for this?  By playing around, it seems ".value"

I need help with conditional formatting.
A B
40 QTD Actual $3,654,317
41 Qtr. Objective $6,332,604

I have entered the following and the row will not change to default
color when $A(whatever) is not equal to "Weekly Subtotal". It does
change to orange when "Weekly Subtotal" is entered into a cell but wont
change back to excel default color if cell is changed back to "". What

I have been trying to sort data from one worksheet onto others and I
read many newsgroup postings and alot of them recommended Ron de
Bruin's scripts. So I took a look and found this one would do what I
needed:

I'm new to VBA coding in Excel and am trying to figure out how to do
this, but I am running lost.
Each month I will have a workbook containing various worksheets, each
worksheet representing an individual account.  The worksheets will be

I'm pretty sure it has something to do with my end if but I'm not really
used to excel programming.
Range("G24").Select
Do While ActiveCell <> 0

I have a list of workbooks and I want to be able to determine which ones have
a link to an external file.   All I want at this point is "YES" or "NO".    
What do I need to do programmatically to capture if a link is present in a
file.  I've got the FINDLINK utility available, but ...