Deselecting range

Mar 5th, 2002, 05:34 PM

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

Mar 5th, 2002, 05:45 PM

Select something else

Mar 5th, 2002, 05:48 PM

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

Mar 5th, 2002, 06:00 PM

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 · Mar 5th, 2002, 06:03 PM

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

Dave Hawley · Mar 5th, 2002, 08:17 PM

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

Mar 5th, 2002, 08:48 PM

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 · Mar 5th, 2002, 08:57 PM

Sure is, try:

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

Mar 5th, 2002, 08:59 PM

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 05:34 PM	#1
Guest Posts: n/a	If you use Columns("A:N").Select in a marco how do you deselect them

Mar 5th, 2002, 05:45 PM	#2
Guest Posts: n/a	Select something else

Mar 5th, 2002, 05:48 PM	#3
Guest Posts: n/a	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

Mar 5th, 2002, 06:00 PM	#4
Guest Posts: n/a	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.

Mar 5th, 2002, 06:03 PM	#5
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	Select the cell you are in and the columns will be deselected.

Mar 5th, 2002, 08:17 PM	#6
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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

Mar 5th, 2002, 08:48 PM	#7
Guest Posts: n/a	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

Mar 5th, 2002, 08:57 PM	#8
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Sure is, try: Range("A1:D500").ClearContents 'or to remove formatting as well 'Range("A1:D500").Clear