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
Bookmarks