id="info"

Microsoft

Office solution: How to select a specific cell when returning to a sheet

This week, learn the solution to the challenge: What's the easiest way to select a specific cell when you return to a specific sheet?

Last week, we asked you to help a user reduce her keystrokes just a bit by automating the selection of a specific cell when returning to the sheet. Emilefyon was the first to respond with perhaps the most traditional solution, adding the following sub procedure to the sheet's module:
Private Sub Worksheet_Activate()
 'Select C3 when returning to the sheet.
 Range("C3").Select
End Sub
It works great and it's easy enough for most users to implement themselves. Thanks To Rudi-S and Ru7of9 for reminding us about the right-click tab shortcut to the module, which makes the process so much easier for users unaccustomed to adding code!

Thanks to everyone for another great challenge. It was unanimous this time around.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks