Better Way to Jump to a Specific Row That's Not Affected by Removed Rows

I'm trying to find a better way to jump to a specific row so that the Examples in my sample file I attached will always align right below A3. You may think that should be A4, but A1-A3 are frozen, so those rows are static. Where A4 would be, is where I would like the Examples to align with when selected.

Essentially, I'm just trying to cut down on scrolling by jumping to an Example section using the Example buttons I created.

Currently, I'm using Range(""), Select which works, but if I delete any rows, then I have to edit the VBA code to update the range. I'm confident there must be a better method.

Example code I'm using:

Please Login or Register  to view this content.

Thanks
Mike

Modify,

If you "name" the cells in Top Left and Bottom right of your ranges, and set that as the Range Parameters, the range should move automatically?

Ochimus

Originally Posted by TMS

Best bet would be to assign Named Ranges that refer to the "jump points". Then you can use, for example:

Please Login or Register  to view this content.

That worked perfectly, thank you!