By using the SHIFT and/or the CTRL keys you can select non-contiguous ranges. However, if you select a cell or area by mistake, there is no built in way to remove that from the selection without losing the entire selection and having to start over. Describes to VBA procedures, UnSelectActiveCell and UnSelectCurrentArea that will remove the Active Cell or the Area containing the Active Cell from the current selection. All other cells in the Selection will remain selected. Your best bet would be to add these to your Personal Macro workbook so that they are available to all open workbooks in Excel. ![]() This procedure will remove the Active Cell from the Selection. Sub UnSelectActiveCell() Dim R As Range Dim RR As Range For Each R In Selection.Cells If StrComp(R.Address, ActiveCell.Address, vbBinaryCompare) 0 Then If RR Is Nothing Then Set RR = R Else Set RR = Application.Union(RR, R) End If End If Next R If Not RR Is Nothing Then RR.Select End If End Sub This procedure will remove the Area containing the Active Cell from the Selection. ![]() Sub UnSelectCurrentArea() Dim Area As Range Dim RR As Range For Each Area In Selection.Areas If Application.Intersect(Area, ActiveCell) Is Nothing Then If RR Is Nothing Then Set RR = Area Else Set RR = Application.Union(RR, Area) End If End If Next Area If Not RR Is Nothing Then RR.Select End If End Sub. A more robust way for deselecting multiple cells is described in this. It does include an extra prompt, but you can deselect an arbitrary number of cells/selections at once (instead of deselecting only the active cell or area) I'm posting the script here, with a small usability improvement (conditionally removed the redundant first prompt from the original post): Sub DeselectCells() Dim rng As Range Dim InputRng As Range Dim DeleteRng As Range Dim result As Range xTitleId = 'Deselect Cells' Set InputRng = Application.Selection If InputRng.Count. Oct 3, 2013 - File this under the “so I remember it later” department. Tonight I was working on a large financial model and banging my head against the fact. The Best Mac Antivirus Protection for 2019 Despite what you may have heard, your Apple computer is not immune to malware. We test the top contenders to identify those offering the best Mac. All of our antivirus for Mac reviews If you have specific requirements or just wish to see other options, below is a list of all the antivirus software we’ve reviewed. Best Mac Antivirus Software. You need an antivirus program on your Mac. That statement may cause some Apple users to argue or walk away, but 2017 has so far seen more Mac malware and adware than. Best mac os antivirus.
0 Comments
Leave a Reply. |