I need an efficient way to find the cell below the last
number in a column in a macro.
Thanks

Does anyone know of a way to merge multiple excel books that will be a
single sheet per book into one file - i can name them in any format and
they will all be in the same directory.  Thanks, Ben

I'm trying to use the SendMail command to send a workbook to two
people, one manager, and one employee, the employee is variable, but
the manager is constant, here's what i have right now
ActiveWorkbook.SendMail Recipients:=Array(myRecipient ,

I'm trying to open another excel file to no avail.  Here's what I have:
Code:
--------------------
   Dim Location As String

I need help devising formulae/VB to do the following:
I have a database list that I copy into Excel as a worksheet.  In excel, I
have many different worksheets that do calculations based on this list.  
Example database list:

http://support.microsoft.com/?kbid=213360
This is   the basic spellnumb
er macro form microsoft
it spells number in english

How do I customize the cells so that if a person puts the mm/dd/yy hh into an
inputbox within my vba code it shows up in the cell as mm/dd/yy hh:00?  
The people using this code are lazy and don't want to type :00 after each
hour.

Trying to write code that moves some data up a row but having troubles
due to ignorance.  The error message on compile is:  "Expected Array"
for the IsEmpty statement.  Can someone help bridge this problem?
Here's the code:

How do I loop this code until the cell that the data is comming from is empty?
Sub clovis_time()
   activecell.Offset(0, 0).Range("A1").Select
   activecell.FormulaR1C1 = "=(RC[-1]-INT(RC[-1]))*24"

I have two worksheets in a single workbook.
WS1
Col A contains dates; Apr-06 thru Mar-07 over a 1,000 rows
Col B is populated with 15 unique category descriptions over the 1,000 rows.

I'm fairly new to VBA. I'm taking db output and wanting to work with
it. However, the number of rows varies greatly. The only way I can
address one of the columns as a range is to use an input box to ask the
user to select the cells. Put another way, I'd like to use the logic

I need to subtotal a range at each change in "CTR" with VBA code.
I acheived this with a macro recording but I can't figure out the next
part which is this.
I need to get the Grand total that appears at the bottom of the sum

TIA
I have a macro that searches a "data dump" from my general ledger and
basically organizes it for review.  I am trying to trap an error when
my macro encounters a range that does not exist.  This is my code:

I cannot find a way to paste an image into a now toolbar icon using VB
macros.
I create a toolbar button when I open a particular spreadsheet, and I
destroy it when I close the worksheet. In this way, my toolbar is customized

I am having a hard time getting formatted text back and forth between excel
and word.  I can take the contents of an excel cell and (through the
clipboard) get it into word in the RichText Format (bold, font size..).  
What I want to do is to be able to edit the text using word ...