I have code to open a workbook at a specific worksheet. This works great! I
still want to be able to do this along with being able to open any other
worksheet at a specific cell. In other words, I want to click on a worksheet
and have cell A242 be in the upper left corner. Does anyone have code to
accomplish this?

rob