I merge 2 cells, A1+B1. I wanna know width and height of the merge cells.
How to know
it?

I made autofilter on range in sheet1 and I need to copy it (only the rows
after the filter) for another range in sheet2 but I need to do it row by row
because for each row in column 3 i need the value from col 5.
For example:

How do I do this?

My data table looks like this:
    A           B            C
   ---------------------------------------------
1  Region     Gas           Sales Price

Is there a way to create frames in Excel like one can do for webpages?
For example if I split my sheet vertically, I want a frame on the left
side which has "links" that if I click them change the sheet I'm
viewing on the right side.

I use version 2003.
Was Formulas taken away from V. 2003?
I right-click on the PivotTable but I don't see Formulas as one of the options.  How do I do Formulas>Calculated field?
Thanks.

I know the question has already been asked. But I am looking for
something specific. I would like to create a weighted average function,
but that would work (also) with array formula, i.e. I would like to be
able to do that:

I am looking for a more elegant (and shorter) solution to grab the
content of an excel range into an array:
Dim grab
Dim value()

I am trying to get away from the cut and paste world.  I have a data dump
that I sort and from that result I have certain fields that I add to a report.
I am trying to find a way to automate this. I am used to formulas (count,
Counti).  Is there a formula that I a missing to ...

I am wondering if the following is possible and if anyone could
assist....
I have data that I am pasting into excel (a1). I cannot adjust the data
(using text to columns) as the data may be in different places but

I have set a simple formula by using HLOOKUP.
The formula has to find a number,  if found ..   it  has to display the
description of that code.
I have no problems with numbers like 1000.1  1000.2 , however when if

I getting an unexpected result when using the following formula, I'm
receiving #VALUE when the formula in J5 returns nothing (the formula in J5
uses "" double quotes to stop an error being shown).
=IF(LEN(J5>0),J5/2*145,"")

I am trying to get a way that will look at a column of numbers... pick the
lowest number and then highlight that number...
i.e.
     3.86

I have two excel files each has unique data
1st file:   SS, Last Name, First Name...
2nd file:  Last Name, First Name, Employee Number
I need to copy Employee Number from the 2nd file to the corresponding employee.

I added a two line macro to clear a range after a button was clicked.
Now this spreadsheet takes 8 minutes to open/close and some unrelated
spreadsheets take 2-3 minutes.  Before this change it took at most 5
seconds to open/close all spreadsheets.  Saving the file is still very