VBA De-select

[Katy Jordan]

Hi, the below retains the selection in worksheet array, how can i get the code to de-select

i tried adding .Range("A5").Select, but the selection is still in place

 With Worksheets(WSary(a)).Range("A6:M" & NR & ",Q6:R" & NR)
        .Borders.LineStyle = xlNone
        .Borders.LineStyle = xlContinuous
        .Interior.ColorIndex = 0
        .Borders.Weight = xlHairline
       [COLOR=Red] .Range("A5").Select[/COLOR]
       End With

 

[jim may]

I'd try the line outside the With Statement, and see if that works..

 

[Katy Jordan]

I'd try the line outside the With Statement, and see if that works..

Outside of that is another with

With Raw


With Worksheets(WSary(a)).Range("A6:M" & NR & ",Q6:R" & NR)
        .Borders.LineStyle = xlNone
        .Borders.LineStyle = xlContinuous
        .Interior.ColorIndex = 0
        .Borders.Weight = xlHairline
        .Range("A5").Select
       End With
End With

 

[Peter_SSs]

If you want to select cell A5, try just removing the '.' from the front of the red line.

Edit: Or if the sheet in question may not be the ActiveSheet, then try changing the red line to

.Parent.Range("A5").Select

 

[tusharm]

Your code is not selecting anything. What do you want to de-select?

Hi, the below retains the selection in worksheet array, how can i get the code to de-select

i tried adding .Range("A5").Select, but the selection is still in place

 With Worksheets(WSary(a)).Range("A6:M" & NR & ",Q6:R" & NR)
        .Borders.LineStyle = xlNone
        .Borders.LineStyle = xlContinuous
        .Interior.ColorIndex = 0
        .Borders.Weight = xlHairline
       [COLOR=Red] .Range("A5").Select[/COLOR]
       End With

 

[Katy Jordan]

If you want to select cell A5, try just removing the '.' from the front of the red line.

Edit: Or if the sheet in question may not be the ActiveSheet, then try changing the red line to

.Parent.Range("A5").Select

I tried both your methods, the data is still selected

 

[Peter_SSs]

I tried both your methods, the data is still selected

Yes, my mistake. If the sheet in question is not the active sheet, you would have to make it the active sheet before selecting the cell.

.Parent.Activate
Range("A5").Select

The other question is do you really need to select this cell since you rarely need to select anything to work with it in vba?

 

[Katy Jordan]

Yes, my mistake. If the sheet in question is not the active sheet, you would have to make it the active sheet before selecting the cell.

.Parent.Activate
Range("A5").Select

The other question is do you really need to select this cell since you rarely need to select anything to work with it in vba?

No i dont need to have that cell selected, i just want the selection de-selected.

Is there a code that will de-select the whole workbook, that might work

 

[Peter_SSs]

.. de-select the whole workbook ..

I don't know what you mean by that.

Did you try the last code I suggested anyway?

 

[Katy Jordan]

I don't know what you mean by that.

Did you try the last code I suggested anyway?

Yeah i tried that code but it didnt work, so i thought if there is a code that will look for each worksheet in Workbook, if cells are selected then de-select them