Scrolling a spreadsheet with a macro

Have been looking for it with Xray, but so far I didn't find anything that  
I think does what I want.

What I want to do is to search for a cell. When I find it, I want it to  
appear as the first row and the the first column. Let's say that I find  
what I'm looking for in C7. Then I want the sheet to scroll so that it  
appears like this:

      C   D   E   F   G   H   I   J…
  7
  8
  9
10
11
12
13
14
15
  ⁝



-- 
Kind regards

Johnny Rosenberg
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help