Select Cell In Center Of Visible Range

I know how to get the address for the visible range by using:

Please Login or Register  to view this content.

If that Visible Range ends up Being A1:Z40, how do I set my active cell to say somewhere around M20?

Thanks, Spence

Originally Posted by Colin Legg

Hi Spence,

How does this suit you?

That's exactly what I needed. I tried almost that same exact logic, but I didn't use the With statement, I just tried putting my variable for the visible range right into the Cells formula.

Thanks for all your help,
Spence