[api-dev] Scrolling a spreadsheet with a macro

2011-03-04 Thread Johnny Rosenberg
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

[api-dev] Re: Scrolling a spreadsheet with a macro

2011-03-04 Thread Niklas Nebel
On 04.03.2011 17:18, Johnny Rosenberg wrote: 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

[api-dev] Re: Scrolling a spreadsheet with a macro

2011-03-04 Thread Johnny Rosenberg
Den 2011-03-04 17:56:12 skrev Niklas Nebel niklas.ne...@oracle.com: On 04.03.2011 17:18, Johnny Rosenberg wrote: 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

[api-dev] Re: Scrolling a spreadsheet with a macro

2011-03-04 Thread Bernard Marcelly
Hi, I always want A1 to be selected, keeping the selection out of the important area. Why select A1 ? Select any other far away cell, e.g. cell KK3000 _Then_ set the first visible row and column. Regards Bernard -- - To