Selecting Rows with Macro
 

Could someone please help with the following

I have a macro that will select some cell say L200

Is there anyway that I can have the macro select all of the row that
the active cell is currently in and also select all the rows to row
600.

So all that is selected is the activecell row and the rest to 600

so if the active cell is in 500 - 500 to 600 would be selected (the
whole row)

Thanks for any help!


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=374157

Selecting Rows with Macro
 

sub macro()

rows(activecell.row & ":600").select

end su

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=37415