Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make sure a Cell is within the current visible window's ran
as Title
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make sure a Cell is within the current visible window's ran
set rng = Activesheet.Range("Z21")
if intersect(rng,ActiveWindow.VisibleRange) is nothing then Application.GoTo rng, true End if -- Regards, Tom Ogilvy "OKLover" wrote in message ... as Title |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make sure a Cell is within the current visible window's ran
Please put the question in the body of the message, not the
subject line. Subject lines get truncated. Try code like the following: If Not Application.Intersect(ActiveWindow.VisibleRange, _ ActiveCell) Is Nothing Then MsgBox "Visible" Else MsgBox "Not Visible" End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "OKLover" wrote in message ... as Title |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make one column or row always visible? | Excel Discussion (Misc queries) | |||
How to make visible all text in cell with word wrap on | Excel Discussion (Misc queries) | |||
How to make the current date appear when i click 'enter' in a cell | Excel Worksheet Functions | |||
HOW DO I REVERT SCROLL BOX TO CURRENT VISIBLE WINDOW? | Excel Discussion (Misc queries) | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) |