avoid to show the cursor movement during the Macro

[chiandu]

Hi I am newbie with macro excel, so sorry for the no so technical question.

I need to create a report in a sheet 1 on base informations reported in the
sheet 2. Now to buiilt the script I am using the ".activate" or ".select"
command and everything seems to work fine but I am wondering if there is a
way to avoid the cursor visualization run up and down on the screen and
avoid also the Sheet 1 to Sheet 2 selecting on the screen while the the
script is running. Is ther a way to work with cells or range without have
that visualization ? Could i Set a variable as worksheet and work with Cell
and Range selection inside the variable ?

Thanks in advance

Marco

 

[Bob Phillips]

Precede the code with

Application.Screenupdating = True

and reset to False at the end.

BTW, rarely need to Select anything, can usually do it directly. Faster, and
shorter code.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

oops, other way round. Set to False at start, and reset to True at the end.

--

HTH

RP
(remove nothere from the email address if mailing direct)