unselecting cells

[atray04]

I have selected a range of cells, but when I open the workbook the cells are still selected. I tried to find a deselect method, but I could not find one in the help files. Does anyone know of a way that I can do this?

 

[atray04]

this is what the vba help files said
Cancel a selection of cells
To cancel a selection of cells, click any cell on the worksheet.
Would I have to write code for a mouse click in order to do this?

 

[Bowers74]

You just have to write code to select another cell:

Sub Select_Deselect()
Range("A10:B50").Select ' Select a range
Range("A1").Select ' Select a New Range
End Sub

;-)


Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[atray04]

wow thanxs, that worked great

 

[Bowers74]

Glad it helped!

You might also want to read through as many of ht FAQ's in the FAQ section of this forum.



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[atray04]

I did look over the faqs to see if there was anything that applys to what I am working on and I did not find much in there. I think I am almost done, this project is turning out to be bigger than I thought.