View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carroll[_2_] Carroll[_2_] is offline
external usenet poster
 
Posts: 31
Default Returning Cell to Upper-Left-Most Corner

Using VBA, I resort a range of cells by clicking on a column header.
After I have resorted based on a different column, the cells that are
visible are sometimes different. I was trying to find some code that
would record the upper-left-most cell into a variable, then return that
cell to the same upper-left-most corner, without changing the cell that
I have currently selected. Is this possible?

Thanks,

Carroll Rinehart