ExcelBanter - How to get cell in a certain place

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to get cell in a certain place (https://www.excelbanter.com/excel-programming/284747-how-get-cell-certain-place.html)

Tommi[_2_]

How to get cell in a certain place

Hello!
How I can get a specific cell to be selected and displayed in upper left
corner of a worksheet?

Thanks!

Regards,
Tommi

Chip Pearson

How to get cell in a certain place

Tommi,

Use code like the following:

Application.Goto reference:=Range("G12"), scroll:=True

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Tommi" wrote in message
...
Hello!
How I can get a specific cell to be selected and displayed in
upper left
corner of a worksheet?

Thanks!

Regards,
Tommi

Tommi[_2_]

How to get cell in a certain place

Thanks very much! Now it works.
BR, Tommi

"Chip Pearson" wrote in message
...
Tommi,

Use code like the following:

Application.Goto reference:=Range("G12"), scroll:=True

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Tommi" wrote in message
...
Hello!
How I can get a specific cell to be selected and displayed in
upper left
corner of a worksheet?

Thanks!

Regards,
Tommi

All times are GMT +1. The time now is 10:40 PM.