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
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,049
Messages
5,569,884
Members
412,298
Latest member
dietitiann
Top