Basically, many objects can be SELECTED, but only one object can be ACTIVE.
If you "select" only one object (sheet, cell, etc.) it also becomes "active" by
default.
Which one you use depends on what you're trying to accomplish.
If you wish to process multiple items, you can use Select and use
Hi Mandeep,
Activate method works only on a single Cell, which much be inside the
current selection and brings the cursor in that Cell.
And, With the help of select method you can select any range, but does not
let you define which cell has the cursor.
Regards
Ashish
--
Are you =EXP(E:RT) or =
