ExcelBanter - .Activate vs. .Select in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - .Activate vs. .Select in VBA (https://www.excelbanter.com/excel-discussion-misc-queries/127490-activate-vs-select-vba.html)

Dave F

.Activate vs. .Select in VBA

What is the difference between .Activate and .Select in VBA?

Example:

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

Dave

Dave Peterson

.Activate vs. .Select in VBA

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

All times are GMT +1. The time now is 02:31 AM.