Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

scroll to a certain row in Excel?

3 Posts 2 Posters 0 Views 1 Watching

N Offline
N Offline
novadProt

wrote on last edited by

#1

Using Com interop, I open an Excel worksheet. With Range's Find - method I search for a certain cell. So far so good. Now the user should be able to edit this cell. But how can I make Excel scroll to that cell ?
N 1 Reply Last reply

0
N novadProt

Using Com interop, I open an Excel worksheet. With Range's Find - method I search for a certain cell. So far so good. Now the user should be able to edit this cell. But how can I make Excel scroll to that cell ?
N Offline
N Offline
Nicholas Cardi

wrote on last edited by

#2

Application.Goto (ActiveWorkbook.Sheets("Sheet2").Range("E6")) Forever Developing
N 1 Reply Last reply

0
N Nicholas Cardi

Application.Goto (ActiveWorkbook.Sheets("Sheet2").Range("E6")) Forever Developing
N Offline
N Offline
novadProt

wrote on last edited by

#3

it works!!! Thanks very much
1 Reply Last reply

0

Log in to reply