setting visible (ie displayed) part of the worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Address of first visible cell 2
Pictures not being sorted in VBA 2
Display selected cell at bottom of screen 2
Opening New Work with Wedpage Content when address is in original workbook 4
Center displayed columns in middle of window 3
Making visible the anchor point for floating drawing canvas 10
Applying a macro to a range of cells 4
Ensuring Selected Cell is Visible on Screen 7

Back
Top