Control/Home

[Mike E Golding]

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

 

[Norie]

Mike

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

Do you just need to activate A7?

 

[Greg Truby]

I think you want:

Application.Goto Range("A7"), True

 

[Mike E Golding]

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]

I think you want:

Application.Goto Range("A7"), True

That works just great, thanks, Mike

 

[Mike E Golding]

I think you want:

Application.Goto Range("A7"), True

That works just great, thanks, Mike

 

[Mike E Golding]

I think you want:

Application.Goto Range("A7"), True

That works just great, thanks.