Address

[S Haspel]

How do you identify the sheet name and cell reference of the existing selected cell, so that having run a macro I can return to the original cell?

Regards
Simon

 

[Richard Schollar]

Hi Simon

Set a reference to the activecell at the start of the routine and then use Application.Goto to take you back to it at the end:

Dim rng As Range
 
Set rng = ActiveCell
 
'...code...
 
Application.Goto rng

 

[erik.van.geit]

Hi,

You can look at the VBA helpfiles for ActiveCell and ActiveSheet

But in the first place you should write your code without "selecting" or "activating" other cells and sheet. Than there is no need o "return" to the cell. If you post a few lines, then someone can show you how to do that.

kind regards,
Erik

 

[S Haspel]

Thank you, I wasn't aware of the Application.Goto function.

Regards
Simon

 

[Richard Schollar]

There are other ways of doing it too eg:

'with rng set as before:
 
rng.Parent.Activate   'activate the parent sheet first!
rng.Activate

but I think you would also do well to bear in mind what Erik said - usually there isn't any need to change the active cell/sheet. You should be able to avoid doing so in many circumstances (adding worksheets is one exception that comes to mind). This would have the added benefit of speeding up your routine (activating, relatively speaking) takes a long time to effect).