Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right Hand Column on Screen
Hi
Can someone give me the code snippet to give the column number of the the column which is at the far right of the screen itself i.e. the returned result will change if the zoom factor of the display is changed. Thanks Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right Hand Column on Screen
Tim,
Try something like the following With ActiveWindow.VisibleRange MsgBox .Cells(.Cells.Count).Column End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tim Childs" wrote in message ... Hi Can someone give me the code snippet to give the column number of the the column which is at the far right of the screen itself i.e. the returned result will change if the zoom factor of the display is changed. Thanks Tim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right Hand Column on Screen
Chip
just the ticket, brilliant as usual! thanks Tim -----Original Message----- Tim, Try something like the following With ActiveWindow.VisibleRange MsgBox .Cells(.Cells.Count).Column End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right Hand Column on Screen
Sub FindColumn()
Dim rng As Range Set rng = ActiveWindow.VisibleRange Set rng = rng.Columns(rng.Columns.Count) MsgBox rng.Address End Sub -- Regards, Tom Ogilvy "Tim Childs" wrote in message ... Hi Can someone give me the code snippet to give the column number of the the column which is at the far right of the screen itself i.e. the returned result will change if the zoom factor of the display is changed. Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel instability - screen scrolls to end of sheet on right hand side | Excel Discussion (Misc queries) | |||
Scroll a cell to the top left hand corner of the screen | Excel Discussion (Misc queries) | |||
how do I "freeze" the left hand title column | Setting up and Configuration of Excel | |||
y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel |