Control/Home

Mike E Golding

Board Regular
Joined
Mar 7, 2002
Messages
71
I have a macro which needs to go to "Ctrl/Home" into the cell A7 which is immediately below my Freeze Frame line. I am sure that I conquered it some years ago but I'm now totally lost...Any help would be appreciated.....Mike
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,344
Office Version
  1. 365
Platform
  1. Windows
Mike

What do you mean by 'needs to go to "Ctrl/Home"'?

Do you just need to activate A7?
 

Mike E Golding

Board Regular
Joined
Mar 7, 2002
Messages
71
Norie said:
Mike

What do you mean by 'needs to go to "Ctrl/Home"'?

Do you just need to activate A7?

Thanks so much for replying but I had a rare flash of brilliance (by my standards and rare in my case...lol). I have got it thanks again....Mike
 

Mike E Golding

Board Regular
Joined
Mar 7, 2002
Messages
71

ADVERTISEMENT

Greg Truby said:
I think you want:
Code:
Application.Goto Range("A7"), True

That works just great, thanks, Mike
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,995
Messages
5,834,777
Members
430,321
Latest member
yemisimi11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top