Very Computer

I would like to periodically "select" either rows or columns and then
perform some function on them like auto outline.  The problem seems to
be in "selecting" these rows/columns using variables.

For examle

sub selectRows (x as integer, y as integer)
  Rows(x:y).Select
end sub

This does not work, is there a way to do this ?

-st

Also, does anyone have some recommendations on Excel 5.0 reference books
that take you beyond an intermediate level ?

sub selectRows (x as integer, y as integer)
    Range(Cells(x, 1), Cells(y, 256)).Select
End Sub

rows is a method while range is an _object_ in this case. an object can
have a _method_ (select).

Quote:>Also, does anyone have some recommendations on Excel 5.0 reference books
>that take you beyond an intermediate level ?

hope this helps.

--

: I would like to periodically "select" either rows or columns and then
: perform some function on them like auto outline.  The problem seems to
: be in "selecting" these rows/columns using variables.

: sub selectRows (x as integer, y as integer)
:   Rows(x:y).Select
: end sub

: This does not work, is there a way to do this ?

Try something like this:

sub selectRows (x as integer, y as integer)
   RowsToSelect = x & ":" & y
   Rows(RowsToSelect).Select
end sub

____________________________________________________________

  John Walkenbach                      San Diego, CA (USA)

____________________________________________________________