I need some help in finding a specific cell address for a selection from
a ListBox.  For example, if  the ListBox.RowSource = D15:D25, and the third
item in the list was selected (ListIndex = 2) the cell address D17 is
returned.  I have fumbled around with relative ...

2003
Row    A    B        C
1        11   13     1000
2        12   12     3333

i have a small program to send emails by outlook in excel.
not sure what's go wrong, the VBA run twice when "the button" is clicked.
however if i run VBA in the editor, it is normal to run once.
therefore, i think it is wrong with "the button" created by "Workbook_Open"

i have this code in a userform called view_employees
now in my code i want to display a list that i keep in a sheet named
"empleados"
if  range "a2" is empty i want to hide the listview i use to display the

Hi.  I would like to find the number of the last row in column "AB" that has
the value "FINAL TEST".  The following will find the first row.  How do I
find the last?  Thanks.
    Columns("AB:AB").Select

Using two ranges, rng1 and rng2, how can I define the range between them?
For example, if rng1 was B2 and rng2 was D10, then what formula can get me
the range from B2:D10
Thanks in advance

I have 4 columns of names. I would like to search all 4 columns (4
individual ranges) and find the names that appear in all 4 and copy the
names to individual cells.
Thanks for any help and Merry Christmas (Happy Holidays..... pc)

I tried to create a Petty Cash Book in Excel. The format is this
________________________________________________________________________
  A                 B                     C
D                   E                    F

I have a workbook with several spreadsheets, which I will be using each month
as a template.  I recorded a macro with the hopes of grouping the worksheets
and then selecting the page setup to create the same footer information,
"Date prepared: & Date", on each worksheet.  ...

I have a sheet that runs macros which open text files, manipulate the data,
and give me a clean, readable output.  Works great, as long as I always have
the same drive as the source.
But I want to give the user an option to choose the drive from which to pull

Can anybody point me to a good source?
Excel 11.
I've poked around, but have not found anything that seems complete - or
particularly clear.   e.g. http://tinyurl.com/y7zlto  Seems tb close, but the

I'm using Oulook Express as my newsreader, as suggested in here.  3
questions:
1) How do I start a new thread?
2) Can I filter the messages to see only the ones from me?

I'm working in Excel 2003 - VBA.
OldRate is a variable whose value comes from user input into a cell.
OldRate=Range("A1")
I am multiplying that variable by 1.075 and need to round up the result to

Hello Group,
I'm new to Excel programming and currently have written a module that
sends a query to a server. Gets some information then it populates
sheet1. Next step is clicking a button which takes the user to a tab as

I have all my code in ThisWorkbook and I have a button in Sheet 1. How
do I get the button in Sheet 1 to point at some functions in
ThisWorkbook?
Thanks.