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
> 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
Excel Programming >> 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
> 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
Excel Programming >> problem in excel sheet
Sorry .. pretty dumb this morning! Niek pointed you in the right direction.
> 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
>
>
>
> > 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
