Excel - Need to select first cell in column <> 0, after list sort

[Acquaman]

Hello, Thanks for helping me out. I really appreciate it.

I am sorting a list of formulas that all have a zero value until some text is typed into the source cells. After an A to Z sort, if the list is only partially full fo text values, the zeros are all listed first and the text values are at the bottom.

I would like to be able to make the cell pointer go to the first text value in the column by which the sort was based on instead of scrolling to find it. If possible I would prefer to keep the column sorted A to Z.

Thanks,
Acquaman

 

[rdeleon]

You cound use the range.find method to find the first non-zero value and then select it.