Its nice to see those replies regarding my little doubts.I feel that they are significant i building up the code.really, thanks for the good explanation to both of u.

I want to know the generalised formula(VBA SNIPPET) for using the code in any macro to check the last cell used /last cell in the column.Also do tell me what does & Mean.