Calculating rows and columns compared to a given cell

[clippan]

Hi, I would like to calculate the number off rows(rw) and the number of
columns (cl) between an ActiveCell and a given cell in a worksheet in a macro.
Then I will use rw and cl for some other calculations.
For example: The given cell is B2 or (2,2).
If the activecell is E7 (5,7) then the answer should be like:
rw = 5 - 2 = 3 and cl = 7 - 2 = 5
If the ActiveCell changes to F10 (6,10) the answer should be:
rw = 6 - 2 = 4 and cl = 10 - 2 = 8.
Can anyone please tell me how to make those calculations?
--
Many thanks in advance !
Clippan

[Don Guillett]

try
rw=activecell.row-2

--
Don Guillett
SalesAid Software
[email protected]
"clippan" <[email protected]> wrote in message
news:[email protected]...
> Hi, I would like to calculate the number off rows(rw) and the number of
> columns (cl) between an ActiveCell and a given cell in a worksheet in a
> macro.
> Then I will use rw and cl for some other calculations.
> For example: The given cell is B2 or (2,2).
> If the activecell is E7 (5,7) then the answer should be like:
> rw = 5 - 2 = 3 and cl = 7 - 2 = 5
> If the ActiveCell changes to F10 (6,10) the answer should be:
> rw = 6 - 2 = 4 and cl = 10 - 2 = 8.
> Can anyone please tell me how to make those calculations?
> --
> Many thanks in advance !
> Clippan