View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
chijanzen chijanzen is offline
external usenet poster
 
Posts: 139
Default 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