Simply select rows

J

JP

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
 
P

...Patrick

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
 
A

Alan Beban

JP said:
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
Click to expand...
Rows("1:" & ActiveCell.Row).Select

Alan Beban
 
J

JP

Thank you, Patrick.
Best Regards,
JP

...Patrick said:
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 said:
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
Click to expand...
Click to expand...
 
Top