Reply to mr preet makkar for his query - intersting query

let me know if you have any simpler solution then this one..

Attached simplification..

password  is 11

hope it works

With inbulid of macro { to clear text from c2:ab2}

---------------------------------------------------------

Sub Clear()
'
' Clear Macro
'

'
    Range("C2:AB2").Select
    Selection.ClearContents
    Range("C2").Select
End Sub

After Modifying- Its Great Sharing , Really Awesme.....

Very nice gaurav... can you let us know how does you make this macro ? actually i want to learn about creting macro's in vba.

Hi Bhayiya (Hope i can call you) .. Well i have never chat with you but i heared a lot about you so thanks for being with us and guide us.. It will be great that i can share something which is / are useful for all members..

Bhaiyya, there are two ways to learn macro, 1. By writing scriptt manually and 2. By recording it... I always use second option.

Attached little Illustrative hope it work.

Originally posted by : Gaurav Aggarwal
	Hi Bhayiya (Hope i can call you) .. Well i have never chat with you but i heared a lot about you so thanks for being with us and guide us.. It will be great that i can share something which is / are useful for all members.. Bhaiyya, there are two ways to learn macro, 1. By writing scripttt manually and 2. By recording it... I always use second option. Attached little Illustrative hope it work.

Hi, Gaurav, Means The Step Which We Do After Recording Option Being On Will be Recorded ?????or What ??

Hi Ayush,

Yes it will record each steps you take after press "Record Macro", but still some commands are there by which you can modify computerized scripttt for required purpose.