controling activecell in a selection through macros

[Suraj3825]

the macro that i have designed does some functions on the cells that has been selected just before running the macro, if the person selects it from top to bottom then it works fine but the problem is wen the person selects the cells from the bottom the whole functions works in an unintended way.

so is there any way that i can write a code that automatically makes the top most left cell of the selection as the activecell or, atleast it shud identify that the selection has been done wrongly and pop an error box and exit the sub.
is this possible?? please help

[hafizimran]

Add this line as the first line of macro:

Please Login or Register  to view this content.