ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Return to a previous cell (https://www.excelbanter.com/excel-discussion-misc-queries/47690-return-previous-cell.html)

Ken G.

Return to a previous cell
 
I have a macro button in a frozen pane which finds and goes to another
occurrence of the contents of the active cell, often several hundred rows
below the active cell. I'd like to have a macro that would take me back to
the first cell.

Ken G.

I figured it out myself. (give self pat on back)

"Ken G." wrote:

I have a macro button in a frozen pane which finds and goes to another
occurrence of the contents of the active cell, often several hundred rows
below the active cell. I'd like to have a macro that would take me back to
the first cell.


jhockstr

I actually have the same problem. How did you do it?

I'm assuming he won't answer so anyone else know this?

Thanks.
jhockstr


Quote:

Originally Posted by Ken G.
I figured it out myself. (give self pat on back)

"Ken G." wrote:

I have a macro button in a frozen pane which finds and goes to another
occurrence of the contents of the active cell, often several hundred rows
below the active cell. I'd like to have a macro that would take me back to
the first cell.



All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com