I've set a window with columns R & S visible and frozen. If I use ActiveWindow.ScrollColumn I get the first visible column to the right of S. What will return 18 (column R) to allow me to work with cursor position values?
I've set a window with columns R & S visible and frozen. If I use ActiveWindow.ScrollColumn I get the first visible column to the right of S. What will return 18 (column R) to allow me to work with cursor position values?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
[VBA]Application.Goto Cells(1, 18)[/VBA]