DId you read response 7 mentioned in my first post.
This tells you how to enter the VBA code.
If you followed it, you need to repeat what steps you took and what errors you get.
Saying there are errors doesn't help. What are the error messages - when do they happen etc.
You say should i put any code prior to the cell ??
I don't know what you mean by this.
Code goes in a VBA window, it doesn't go in a cell or prior to a cell.
You also asked how to insert the cell no ?
What does this mean. Is 'no' short for number?
Where do you want to insert this 'cell no'.
Cells have addresses such as A1, consisting of a column and a row.
In VBA, a cell is a Range object and is addressed like this Range("A1")
As cells are on Worksheets, then it is necessary to identify which worksheet the cell is in:
or the active worksheet :
Have you tried getting a couple of simple VBA macros working first. At least then you know that you have the basic ability to get a macro to work.