last = range("A65000").end (xlup).row
rows("1:" & last).select


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel



"JP" a écrit dans le message de
. ..
I have been trying to simply select rows starting from the first row and
ending at the cursor's row.
For example, instead of ending the selection at row 13, as in:

Rows("1:13").Select

I would need:

Rows("1:[put something here that ends the selection at whatever row the
cursor is on]").Select

I've tried various configurations to no avail.
Thank you,
JP