vbamol

Hi,
I am working on an excel macro.
Is there a method whereby I can take the control to a particular cell in the current active sheet.
e.g if the control ( cursor) is in say cell C 10. when the user runs the macro the control (cursor) should go in cell S 22.
How can I do that.
amol

masim

Use Range("S22").select at the start of your macro.

Regards
Asim

vbamol

Hi Asim,
The method you suggested worked fine.
Thanks a million.
amol