Dim ActCell as range
....
Set ActCell = activecell
'do a bunch of stuff

'go back
application.goto actcell



Bob Zimski wrote:

I have a VBA that does some processing on a workbook and then opens another
workbook for some vlookups. The problem is that when I open the second
workbook it becomes the active workbook. What I would like is to somehow have
the workbook name stored in a variable and then open the second workbook.
Then, using the stored name of the first workbook, activate it. What set of
instructions do I use. I am in the process of learning VBA and don't have a
big enough vocabulary or mastery of the nomenclature yet.

Thanks

--

Dave Peterson