Hi all
I am not an experienced writer of VBA but I would like to capture m
next problem since this comes back quite a lot.

As you can see in the attached Excel file I have several columns o
varying length. To the right of each column there is an empty colum
(coloured yellow).

What I need to do is calculate the rank of a number in the column nex
to the yellow cells (e.g. range c8..c11) As you can see I need t
repeat this in this file alone several times, and this is only 1 o
several 100s of files!

I know what steps to take when doing it by hand but how can I captur
the next actions in VBA?

1. type =Rank(
2. go to the top cell of the range I need to calculate the rank an
select this cell and type ";"
3. go to the same cell, type "." and go to the bottom cell of th
needed range (simply "end-down" won't do the trick since sometimes th
range of cells has blanks)
4. make the selected cells "absolute" by typing F4
5. "enter"
6. copy the range with the ranks which I've just made and make th
values absolute through "edit-paste special and choosing values"

This last procedure is needed because I need the outcome in a
different program

I hope it is not too much asked but thanks for your helping hand

Hei

--
Hei
-----------------------------------------------------------------------
Hein's Profile: http://www.excelforum.com/member.php...fo&userid=2474
View this thread: http://www.excelforum.com/showthread.php?threadid=53134