ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Region (https://www.excelbanter.com/excel-discussion-misc-queries/118702-region.html)

Zaahir

Region
 
Hi

This sumthing realy simple, but i cant get it going.

How do i select current region of data using hotkeys?

regards

Stefi

Region
 
One way is to install this macro
Sub SelCurr()
Selection.CurrentRegion.Select
End Sub

and assign a hotkey to it (Alt+F8/Click on SelCurr/Options(bottom button)

Regards,
Stefi

Zaahir ezt *rta:

Hi

This sumthing realy simple, but i cant get it going.

How do i select current region of data using hotkeys?

regards


Dave Peterson

Region
 
ctrl-*
(ctrl-shift-8)

Will select the current region.

Zaahir wrote:

Hi

This sumthing realy simple, but i cant get it going.

How do i select current region of data using hotkeys?

regards


--

Dave Peterson


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com