I have been running the below code in an Excel Macro without any issues to
copy selective rows of data to a temp1 worksheet based upon a autofilter
selection.  After I went to Office 2003 Professional for Office XP Pro, I
get a run-time error '1004' on the line for the UsedRange ...

I've inserted a Word Document Object into my spreadsheet and would like to
remove the border that appears around it for printing?  Any help would be
appreciated.
Thanks!

Hi, as above really.  Word has this option for its fields but I can't find
how to do it *easily* in Excel :)

Say, I have csv with 200 addresses in it. Would it be possible to break down
the file or export the records into multiple csv's with like only 25 records
per file?
I know it sounds a little crazy, but the reasoning is that I need this for

OK, I'm trying to make a league table of our branches within the company
based on various criteria then put them in order of points 'scored', I wish
to do this automatically.
Am using the LARGE function along with INDEX/MATCH, which is fine however if

I have a worksheet made up for different cost centers
with reference to invoices. For example who they are
from, what date is on the invoice, what date did we
receive it, amount, etc. I have written the following

I'm using Office 2003 and the Excel module.
I have a spreadsheet with 3 columns.  Columns A and C include names and
phone number of people.  Column B is just a blank divider.
If I have the sheet alphabetized, with 10 names and numbers in column A and

This above symbol will not let me sort by data in column.  How can I delete
symbol?

I wish to use the SUBTOTAL function, to count the number of rows
when using 'Autofilter'
I have this formula: =SUBTOTAL(3,B5:B300)
The problem is that all cells in the range B5:B300 contain formulae,

I am currently using Excel in Office 2000. Is it possible to create a form
on screen and designate the form labels as non-printing while the data cells
would print? i.e this would be necessary to use an on-screen form with a
preprinted form. I can hide the label cells but then they ...

is there a way to set columns to not accept duplicate information?

I'm a data entry clerk who works with UPC codes a lot.  I'm trying to import
an Excel spreadsheet table into Access to check it against our database for
missing items, but I find that an error/problem at the Excel level is keeping
me from doing this.

Can someone please tell me the shortcut for inserting a cell or sells.
thanks
Daniel

I have 55 workbooks that are filled with formulas that take data from other
workbooks.  I would like to get rid of the formulas, but keep the data.  I
would like all compiled workbooks to have any references eliminated.  How
can this be done?

I need to use the format of an Excel spreadsheet that I have created as a
template for other worksheets in a book and other books. How can I accomplish
this, if possible?