Simply select rows

[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

 

[...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

 

[Alan Beban]

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

Rows("1:" & ActiveCell.Row).Select

Alan Beban

 

[JP]

Thank you, Patrick.
Best Regards,
JP

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

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