I have a spreadsheet that has 44,383 rows.  I am trying to use the following
macro to fill in the blanks for columns A:D.  I am getting a REF error.  I
know it is the number of rows because the macro works for spreadsheets that
do not have as many rows.  Is there any modification ...

Hi,
I'm trying to link to an external workbook.  Let's say the formula is:
G:\2007\2007 Jun\blah.xls
I would like to be able to change "Jun" by referencing a cell.  I've read

Dear Sir,
Currently I find that there are some lackins in the Subtotal Table (i.e.
Data > Subtotals >.
The Subtotal heading is in bold but not the number, and there is no blank

Hello,
I have a worksheet that has some long text in a column of cells.  Some of
the words contain right-slant apostrophes ( ’ ) which cause problems with the
program that imports this data.  Since there are many instances of this

HOW DO YOU GET THE SUM TO SHOW ON THE READY BAR ??

I know that you can link two worksheets/workbooks using Special Paste and
then Paste Link. When I enter data into the master worksheet, the new-copied
worksheet changes, however when I do the reverse, enter data into the
new-copied worksheet, the master does not change. What can ...

I was wondering if anyone had a template (or advice on creating a template)
for a simple reservation book for a small hotel or vacation property?  It can
be in any Office program.  Thanks so much, Michelle www.ecomexico.org

I frequently save file properties such as the title, author, company name etc
and wanted to be able to use these values in excel without having to retype
them in the spreadsheet.
I can do this in word using the insert field function in Microsoft word, do

I created a 15-tab spreadsheet.  Most of the tabs interact in some fashion.
I want to email certain tabs without the others attached.  Is this possible?

can anyone tell me if theres any errors in this and what the outcome
would be?
sub test ()
dim I, J As Integer

Apparently I can set up a spreadsheet to sort data by placing hot key in the
column indicator cell. (Similar to the newest on top in outlook)
How do I do this??

Typing "..." gives me a verticle line in Excel 2007. how do i disable this?

I only want to print certain columns from my worksheet.  I'm using CTRL to
select discrete columns.  Is it possible to just print these columns fitted
to one page (without space inbetween and without each column placed on a
separate page)?

I spool a report from a software into excel which gives me a huge data which
contains Date as below
eg. in Col A shows date with time
A1 = 10/08/2007  6:41:40 AM

  I 've created a Userform called "Result",I need to open this form on the
event of a click event of button,i need also to that,for example the textbox
"Score" on the form equals the cell "Answer!C22" on the sheet?
Can anybody help?