select the cell that was active before it ran

[moike]

I am trying to have a macro return to the cell that was originally selected before the macro ran. That starting location is assigned as a variable (we'll call "Start").

What syntax is necessary to ensure the location we named "Start" is the active cell after the macro runs.

This is probably very easy but haven't had much luck searching for the answer.

[royUK]

This shouldn't be necessary, because most actions in VBA do not require selecting any cells or ranges.

Dim rStart as Range

Set rStart = ActiveCell

'your code

rStart.select

[moike]

I appreciate the help. That is exactly what I needed.

[royUK]

moike, like I said, you probably don't need it. If you post your code I can tell you better whether it's necessary.

[moike]

The code is very long unfortunately but I can give you a summary of what it does.

It's a template that collects financial data from Analysts for processing Journal Entries. There is a separate template that must be used to actually create an extract and load into our Financial systems and my goal was to verify all fields match on both templates. The macro entails moving from different locations on the template to assign values to variables and then compare the values present on the other template. I wanted to ensure that the cell that was selected before the macro ran was the cell that was selected at the end even though there was movement in between.

The syntax you provided does just that but I'm always interested to improve the code if there is a better method.

Thanks again

[royUK]

You don't need to Select a cell to assign a Variable

Myvariable =Cells(1,1).Value