Deselecting range

[Guest]

If you use Columns("A:N").Select in a marco how do you deselect them

 

[Guest]

Select something else

 

[Guest]

I know I can do that but I did not want to move out of the cell I am in, tried using deselect but it want work

 

[Guest]

As far as I know, there must be at least one cell selected in a worksheet - i don't think it's possible to have nothing selected.

What exactly are you trying to do?
It is rarely necessary to do any selecting/activating in macros and doing so merely increases run times.

 

[SamS]

Select the cell you are in and the columns will be deselected.

 

[Dave Hawley]

As has already been said it is very rare that you should need to select an Objects with VBA. But if you do just use:

ActiveCell.Select

 

[Guest]

I am selecting the range to clear it is there anouther way to do this with out selecting it, but I want to end up in the cell I was in which could be different each time. ActiveCell.Select takes me to A1

 

[Dave Hawley]

Sure is, try:


Range("A1:D500").ClearContents
'or to remove formatting as well
'Range("A1:D500").Clear

 

[Guest]

Thanks