viewing the cell reference as the top row

  • Thread starter Thread starter bobclark
  • Start date Start date
B

bobclark

within a macro I want to have the cell I call be the top row for viewing,is
this possible?
 
yes, it is possible.

Use the ActiveWindow.ScrollRow command. For example, setting
ActiveWindow.ScrollRow = 10 moves row 10 to the top of the screen.

You just need to replace "10" with the row of the cell that you call, it can
be a variable, and it should work.

Katie
 
I've tried several methods BUT

how can I now move the cursor (active cell) to that row?



On Wed, 13 Oct 2004 00:51:04 -0700, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:

~>yes, it is possible.
~>
~>Use the ActiveWindow.ScrollRow command. For example, setting
~>ActiveWindow.ScrollRow = 10 moves row 10 to the top of the screen.
~>
~>You just need to replace "10" with the row of the cell that you call, it can
~>be a variable, and it should work.
~>
~>Katie
~>
~>"Bob Clark" wrote:
~>
~>> within a macro I want to have the cell I call be the top row for viewing, is
~>> this possible?
~>>
 
Maybe you could try this, dad.

Option Explicit
Sub testme()
Dim myCell As Range
With ActiveSheet
Set myCell = .Range("x33")
Application.Goto myCell, scroll:=True
End With
End Sub

What's for dinner?
 
Well tonight it's chicken parmesan, saffron rice and a nice chardonnay (it's
wonderful living in wine country). Tomorrow we're having Roasted Rack of Lamb
with Garlic and red wine sauce, maybe a Caesar salad (from scratch, of course)
with asparagus fried in a butter, white wine and garlic sauce. Don't be late,
you know how the evil step-mom can be.

And Thanks, son

On Fri, 15 Oct 2004 15:12:12 -0500, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:

~>Maybe you could try this, dad.
~>
~>Option Explicit
~>Sub testme()
~> Dim myCell As Range
~> With ActiveSheet
~> Set myCell = .Range("x33")
~> Application.Goto myCell, scroll:=True
~> End With
~>End Sub
~>
~>What's for dinner?
~>
~>
~>Bob, Clark wrote:
~>>
~>> I've tried several methods BUT
~>>
~>> how can I now move the cursor (active cell) to that row?
~>>
~>> On Wed, 13 Oct 2004 00:51:04 -0700, in microsoft.public.excel.misc falling
into
~>> the bathtub with your monitor, the short circuit caused the followingto
~>> mysteriously appear from your keyboard:
~>>
~>> ~>yes, it is possible.
~>> ~>
~>> ~>Use the ActiveWindow.ScrollRow command. For example, setting
~>> ~>ActiveWindow.ScrollRow = 10 moves row 10 to the top of the screen.
~>> ~>
~>> ~>You just need to replace "10" with the row of the cell that you call, it
can
~>> ~>be a variable, and it should work.
~>> ~>
~>> ~>Katie
~>> ~>
~>> ~>"Bob Clark" wrote:
~>> ~>
~>> ~>> within a macro I want to have the cell I call be the top row for
viewing, is
~>> ~>> this possible?
~>> ~>>
 
If I don't get adopted, can I just make reservations for dinner?
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
make Hyperlink jump on the top row 2
Excel Is this possible?? 3
How To Have A Cell Be Blank If... 2
VLookup Variable Offset 1
How to insert row and column labels into a single cell 3
Cell references within formulae 1
Pasting into a filtered sheet 3

Back
Top