ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Select a particular cell (https://www.excelbanter.com/excel-programming/407854-select-particular-cell.html)

ordnance1

Select a particular cell
 
I need a macro that will go to cell A8 when run. So if I am down on row 3200
it will take me to cell A8 making that cell active and visable.

Gary''s Student

Select a particular cell
 
Sub make_a_beeline()
Range("A8").Select
End Sub

--
Gary''s Student - gsnu200774


"ordnance1" wrote:

I need a macro that will go to cell A8 when run. So if I am down on row 3200
it will take me to cell A8 making that cell active and visable.



All times are GMT +1. The time now is 06:01 PM.

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