New users : After Open Book and paste valuse

[azazelchau]

Hi all,

I am a new comer in VBA world. Please kindly help me to solve the 101 problem.
I want to paste 3 value in cells after open the workbook. However, after i click yes, i can't see the value is pasted

The code is below :

Please Login or Register  to view this content.

[jason.b75]

It is my guess that the sheet that the code should work on is not active when the workbook is opened, allowing the code to run on the wrong sheet.

Allowing for that, and cleaning the code up a little.

Please Login or Register  to view this content.

Note that the code is set to run on "Sheet2", please change this to the name of your sheet.