ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CTRL and END function (https://www.excelbanter.com/excel-worksheet-functions/34340-ctrl-end-function.html)

Andy787878

CTRL and END function
 

Hopefully a quickie....

Anyone know how to change the cell this function goes to ?

At the moment on one of my sheets it goes down to row 3200+ column E
which is miles more rows then my information is on.

I'd like to set a Macro up which is why i'm asking....

Many Thanks


--
Andy787878
------------------------------------------------------------------------
Andy787878's Profile: http://www.excelforum.com/member.php...o&userid=15792
View this thread: http://www.excelforum.com/showthread...hreadid=385377


Anne Troy

Try this, Andy:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Andy787878" wrote
in message ...

Hopefully a quickie....

Anyone know how to change the cell this function goes to ?

At the moment on one of my sheets it goes down to row 3200+ column E
which is miles more rows then my information is on.

I'd like to set a Macro up which is why i'm asking....

Many Thanks


--
Andy787878
------------------------------------------------------------------------
Andy787878's Profile:

http://www.excelforum.com/member.php...o&userid=15792
View this thread: http://www.excelforum.com/showthread...hreadid=385377





All times are GMT +1. The time now is 12:19 AM.

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