Modify this code to select different column

Hi!
There is a long alphabetized list of clients on the worksheet, and column E contains their last name. At the top of the sheet, there is one button for each letter. Using the code below, you click on the letter you want, and the page jumps to the first row that contains that letter. It works awesome, but I'm looking for it to select the same row, but column D, instead of column E.

How do I modify the code below to select column D instead of E?

Please Login or Register  to view this content.

Thanks!

Hello there,

Try

Please Login or Register  to view this content.

Can you please post a sample of your workbook?

Thanks!

Originally Posted by rvasquez

Can you please post a sample of your workbook?

Thanks!

Sure. It might take a minute to extract the page to a different workbook and change all the namesand stuff, but sure; hang on.

Okay,
Here is a sample. Please check out the comments.

Okay, if I'm understanding correctly the following should work

Please Login or Register  to view this content.

Great, glad to help! Thanks for the star tap!