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