Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simply select rows
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simply select rows
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simply select rows
JP wrote:
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simply select rows
Thank you, Patrick.
Best Regards, JP "...Patrick" <http://cerbermail.com/?KPW0tTCjFw wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select 'Sort By' column by simply typing heading letter | Excel Worksheet Functions | |||
filtering simply | New Users to Excel | |||
How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
can this be done simply ? | Excel Discussion (Misc queries) | |||
Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) |