Siraj,
I am sorry but I don't understand your questions: can you give
examples.

For (1) do you mean:

MyCol=range("AA3").column ... MyCol=27

For (2)

Only you know which sheets you want but you can loop through sheets:

For each sh in Thisworkbook.sheets <== Loop through all sheets

shName=Sh.name '<==== name of sheet
shname.activate
.....
Next sh


"SIRAJ" wrote:

1)Is there any check or formula in excell sheet for column to check the
double entry? if so please let me know.

2) My second problem is that when open a excel file then found 03Sheets in
the file, If I have a excel file which have a lot of sheets then which are
find out specific sheets? which i want. thanks