problem in excel sheet
 

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

problem in excel sheet
 

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

problem in excel sheet
 

Sorry .. pretty dumb this morning! Niek pointed you in the right direction.

"Toppers" wrote:

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