Jimmy

Worksheet event code.

Private Sub Worksheet_Activate()
Application.Goto Reference:=Range("AX100"), Scroll:=True
End Sub

Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module.


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 05:41:04 +0800, "jimmy" wrote:

Thank You..
One more question, How to set the display to a specific sheet cell where
outside the screen when the sheet activate? e.g cell AX100....

"Gord Dibben" <gorddibbATshawDOTca
m...
Jimmy

Something like this..........

ActiveSheet.Range("B2").Resize(10, 10).Value = _
Worksheets("Sheet2").Range("A1:J10").Value

Or more simply.........

Range("B2").Value = _
Range("A1").Value

which bypasses using the Clipboard (and is analogous to Paste
Special/Values)


Gord Dibben MS Excel MVP


On Sat, 3 Mar 2007 03:53:54 +0800, "jimmy" wrote:

Which command is copy the cell value instead of the formula?

Thank you