What is the purpose of an array formula and how is it used?  

Okay, I'm trying to get the INDIRECT function to look up a UNC address
stored in another cell so based upon this formula:
=VLOOKUP("my data",INDIRECT("'C:\temp\[spreadsheet.xls]sheet1'!$C$12:$I
$17"),1,FALSE)

I cant seem to figure this out.
Im not sure if it is a formula or a conditional or using both or maybe only
in VBA but not sure.
I want a row to change background color when a certain word is put in it.

How do modify the following code below so that the value in texbox1 will also
be inserted in sheet5 cell "A1"
Set LastRow = Sheet2.Range("a100").End(xlUp)
LastRow.Offset(1, 0).Value = TextBox1.Text

I have just recorded a macro which takes info from imported text and does
some caculations and rearranges the info onto a new worksheet.  My problem is
that I need it to do the same thing over several worksheets.  I have
associated the macro with a button - but need it to update ...

I have a product that can have four components in it, but there are nine
options.  Is there a way to write a formula to limit the other options once
one has been picked?  Example would be if I have a fruit basket and customers
can pick 4 items to fill it.  They have the choice of ...

I have an excell sheet with 3500 cells on it. There is 161 cells scattered
thought with the word bicycle...How do i take those 161 results and paste
them into a new worksheet.

Is their a way to send a spreedsheet with a macro rule trought email. The one
i am cunsorne with is the time stamp macro, provided by McGimpsey in the link
below. I figured out how to use it but know i am trying to send it to some
customers but the formula does not work. The ...

My data looks like so (excerpted, I've got about 600 rows of data or more):
01    2005    106108    200000    0.2
01    2008    106108    150000    0.2
01    2009    106108    390000    0.4

I have a workbook with 9 worksheets.  I've followed the instructions from the
following link: http://contextures.com/xlfaqApp.html#Unused.  However, I
still have all of the rows below my data.  Is there another way to delete
unused rows?  Or do I need to check to see if there is ...

one more question: how do I do the set up, if I want to have the freezed
column printed on each page?

I will be exporting files from Crystal Reports and importing them into Excel.
My question is: is there a way i can remove all the Blank rows and Blank
columns in Excel in one shot or do i have to delete each line or group of
lines?  If there is a way to do it in one shot how would ...

Here is my thing: I have a set of data that has a column of key numbers (not
in any order) with data referring to each number in the same row. I can sort
the key numbers in order of date because i know what numbers correspond to
what date (another sheet has both on it). I need to ...

If I have 8 in A1 and 2 in A2 I get 25%.
But if I have 8 in A1 and 0 in A2 I get #DIV/0!.  When I want to get 0
or 0%.
Simple remedy?

I am working in Excel and I have all my margins, my header, and my footer all
set to zero.  I want the page to flush out (to truly not have any margins =
no white border).  Is there any way of doing this?