From: Dave F on
What is the difference between .Activate and .Select in VBA?

Example:

Range("B1").Activate vs. Range("B1").Select

Dave

From: Dave Peterson on
Try:

range("a1:D99").select
range("b17").activate

And you'll see.

(It depends on what was selected before that line (.activate).

Dave F wrote:
>
> What is the difference between .Activate and .Select in VBA?
>
> Example:
>
> Range("B1").Activate vs. Range("B1").Select
>
> Dave

--

Dave Peterson