Thanks Patrick,

My problem is in my program I take a cell location from user(e.g.
Sheet1!A1). and inserts value in it using
Worksheets("Sheet1").Range("A1").Value=10.
I again want to insert value in it but now sheet1 is renamed to
Sheet1_old. Now How can I insert the value using the above macro. I
cant use Codename(Changing the sheet name doesn't change the code
name) in VC++