I need to be able to choose from a List of numbers 30.00 through 32.00. Such
as 30.00,30.01,30.02......
I tried a List box but it only holds 40 selections. Is there such a thing as
an "extended" List box that will hold 200 digits? This is only for my

I am looking for VBA code that will insert a row. However,
EntireRow.Insert seems to insert a row and then paste the clipboard
contents into the new row. Is there a VBA method that will insert a row
without this paste behavior?

I have an excel sheet which has a number of named cells (say NM1, NM2,
NM3, etc). I do not use all the names everytime. Is there a way to
check from a macro if a named range is being used in the active sheet
or not ?

I have a spreadsheet containing a row with data something like:
A  |  B
____________
1  |  1111

I have this formula that keeps producing a "HD" in the destination cell H8
even though it reads this way...
=IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8=""),"",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8=49),"NGP",IF(AND(Y8,AA8,AB8,AC8,AL8,AW8,BJ8,BN8,BO8,BQ8,BR8<=48) ...

I need to see the doc preview in the "open window". Right now what I get is a
"Preview not available" message.

Hey guys
I have this idea of making my summary useing dynamic range-reference.
EXAMPLE
Monthly amounts is placed i cell A4 to L4 (Jan...Dec)

First of all, I have to tell everyone who responds to post how WONDERFUL this
is. I've gotten a LOT of information from you smarties.
I have a workbook with several tabs. One tab has a series of tables for
ordering merchandise by size (lengths across the top, in columns, widths

HI folks, thanks for the wonderful resource here. I've found a lot of answers
but I had to ask this one ...
I'm working on a spreadsheet that tallies if certain criteria have been met.
Range N15:N31 has three possible answers Y, N or N/A

I have a spreadsheet that is a dump from a survey. Problem is,
sometimes the dump puts data that should be in one row on two. I need
to write a macro that will see there is a second row, and if there is,
move it up one row. It's easy to identify which rows need to get moved,

I am running MS Excel XP (2002) with all the latest updates.
When I open any speadsheet and either save or print preview, the CPU
spikes to 100% and it takes at least 1 minute for the operation to
complete.

Whenever I open excel file of large size such as 8mb and more excel gets
hang.
Is there any file size restriction so that it will work smoothly or is there
any solution to this.

In Excel is it possible to create a name range that contains multiple name
ranges.  As an example, I have created several name ranges with one cell
reference, such as Sales(A2), COS(A5), ADM(A7), SELLING(A8), MRKT(A9).  I
would like to create a name range that I could include the ...

A colleague of mine has the Excel version '97 on his computer and would like
to know if you can also freeze panes in his version (he has a Dutch version)
at home.

I have a workbook that has multiple worksheets and 2 of them are letters.  I
would like to autofill data into the letters by using the userform.  I have
been able to code it using 1 worksheet.  Is it possible to use same userform
for the different worksheets?