I have a coloumn(O:O) in sheet1 that has many different values. I want
to copy the unique values to sheet 2 cell C3 to C25. How can I do that
using a VBA codec. I am very new to VB that is why I am asking to help
me.

I saw one which does this but the problem is that it asks for a prompt.
I dont want the prompt but it should directly paste to the cell
refference.

The link is http://www.freevbcode.com/ShowCode.asp?ID=4941