I'm trying to set the rowsource of a listbox, I keep getting subscript out
of range error.
Thanks
Wendy

OK, I know the title seems confusing, sorry about that.  Here is what I am
looking to do.  I have a list of stock numbers in column D for example
(10001).  In comlumn G, I want to have it auto fill with a file name that has
the stock number in column D with ".jpg" at the end ...

I am trying to make a Macro that will select a few cells and random number
between 1-100 (I have done this). But when I use =RANDBETWEEN(1,100) whenever
I change a number in my cells it randoms. I was wondering whether there was a
=random that doesnt do after every recalculate. ...

I am having an issue printing text that is wrapped. It is NOT a merged cell;
the column has a fixed width; the cell has wrap text turned on and it is set
to auto fit. (This is important as I have a workbook with over 150
worksheets; each worksheet has 27 rows with text in this ...

Below is a macro I want to run when I open a workbook.  I need to make a
change though however and I don't know how to language the code.
I only want to run the macro below if there is a value in cell F8. If F8 is
blank, then I want to end the macro, or just do nothing.

I use a spreadsheet (Excel 2002 SP3) for maintaining a database of archived
client files. It has about 3,100 rows and uses Autofilter on each of the 10
columns.
I find that the drop down list from the Autofilter in the column by which

I have a particular easy macro I created that runs when I open a quote
workbook.
I have a separate workbook where I log all my quotes with quote numbers. On
my "Blank Quote" workbook I have a cell (out of the print area) that returns

I use exel to keep track of IP addresses. How do I sort on a column so the
numbers will be decending I use text or general and it will put
1,11,12,13...2,20,21 and so on. Would like to have it sort 1,2,3,4, and so on.

Good Morning Dave,
I'm wondering if it's possible to add an additional condition to the Match
Row for the Sheet1 look-up?
After the Sheet1 Match is found in Sheet2 Column A, I'm also looking to add

The column headings and the row headings on my sheets are backwards.

I'm looking for a business solution here. Maybe someone could point me
in the right direction. I want to find a vendor of a system that can
post a specific spreadsheet on large wall mounted flat panel displays
in multiple locations within a building. It's for production updates.

I have data in a column from A2 down to around A800.  The data is filtered by
auto filter.
I can get the sum of the visible data with =SUBTOTAL(109,A1:A1000).  This
works just fine.  Now I want to get the sum of only the last 7 visible

I have a problem in calculating the uncertainty (95% ci) of particulate mass
concentration. The weighings of the PM mass have been done 3 times in
different days under same conditions.
I hope you have the solution.

Hi, when I hit the tab key the cursor is advanced to the next cell just after
the rightmost cell in my window.  I have played with the protection of the
cells and the worksheet and it makes no difference.  It does this on my
machine, no matter what worksheet I select (even on ...

I need step by step instructions to do this, if is even possible...
I want to create a number of items in the clipboard that I save with the
worksheet/or workbook.  So when I return to add new data the cells that have
the same contents do not have to be reposted to the clipboard ...