| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting visible (ie displayed) part of the worksheet
After completing a macro, I want the displayed view of the worksheet to be
anchored with a particular cell in the top left corner of the window. How do I do this in the general case where to top left cell is CnRm? And is there a simpler way when the anchor cell is C1R1? TIA ... Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting visible (ie displayed) part of the worksheet
gvm:
try: Application.Goto Range("B20"), True -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "gvm" wrote: After completing a macro, I want the displayed view of the worksheet to be anchored with a particular cell in the top left corner of the window. How do I do this in the general case where to top left cell is CnRm? And is there a simpler way when the anchor cell is C1R1? TIA ... Greg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting visible (ie displayed) part of the worksheet
thanks for the reply. This had the effect of putting column IM, row 65526 in
the top left corner! I can't figure it, I was looking at far bottom right corner of the sheet! Very strange! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only Part Of Text Displayed In Cell | Excel Discussion (Misc queries) | |||
| Chart not visible -suspect scale setting? | Charts and Charting in Excel | |||
| Setting hyperlinked cells to be displayed at the top of the screen | Excel Discussion (Misc queries) | |||
| Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. | Excel Programming | |||
| How do I find and replace part of a hyperlink that isn't visible? | Excel Discussion (Misc queries) | |||
Linear Mode
