Once screenupdating is set to false, it is not automatically turned on
after code is executed. You have to set it to true in your code, or you
have to quit excel and restart it.

When screenupdating is set to false, if you are selecting any ranges on
the sheet which was active just before setting screenupdating to false,
then you can see the on the screen that different ranges are being
selected.

Well to add rows / columns or data it is not neccessary to activate or
select the sheet.

See bellow example, run it with Sheet1 being active, it will add column,
row and data in to sheet2 without selecting or activating it.

With Worksheets("Sheet2")
With .Range("A5")
.EntireColumn.Insert
.Value = "xyz"
End With
With .Range("D5")
.EntireRow.Insert
.Value = "abc"
End With
End With
End Sub

Sharad


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!