Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi, I have this code here for a selectionchange event on one of my worksheets. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range(Cells(Target.Row, 4), _ Cells(Target.Row + Target.Rows.Count - 1, 30)).Select End Sub This works great as long as the range I want is contiguous. How would I go about changing this code to only keep selected rows if the user holds the CTRL key and selects random rows? I don't know if this is even possible but I've played with the intersect method and this doesn't seem to be a solution. Any input is appreciated. Thanks, Mjack -- mjack003 ------------------------------------------------------------------------ mjack003's Profile: http://www.excelforum.com/member.php...fo&userid=5141 View this thread: http://www.excelforum.com/showthread...hreadid=539927 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Thanks Ardus. Didn't even think about that...ingenious! :) One problem though...the user is selecting from a very long list. Haven't really put any thought into this yet but is there anyway to keep the screen from centering to the intial selection...which distracts the user and causes them to lose how far down the list they had scrolled. Thank you for the quick response. Mjack -- mjack003 ------------------------------------------------------------------------ mjack003's Profile: http://www.excelforum.com/member.php...fo&userid=5141 View this thread: http://www.excelforum.com/showthread...hreadid=539927 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I reference data from one worksheet to another using combob | New Users to Excel | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions |