Changeing Collections Indexing

[Bill Case]

Hi;

1) For neatness and memory's sake: Is it possible to change the Index order
of a collection of objects. For example, in a project that I have just
finished I have a number of worksheets (which I refer to by name -- so I am
OK) that I have moved around so that the worksheet index number no longer
reflects the tab order. Can I reorder the index number so that
'Worksheets(1)' is now the first tab in the workbook? I have the same kind
of question for other collections.

2) During the creation of my latest little project, I developed a list of
about 10 or so general VBA programming questions. Some of them are quite
newbie, I am sure, but others are more difficult and may take a couple of
posts to straighten out. Should I ask them here, or can you recommend a
better site/list.?

Regards Bill

 

[Tom Ogilvy]

worksheets(1) is always the first worksheet in the tab order.

the index changes with the organization of the tab order.

You can ask programming questions here. Best to put each question in a
separate post unless they are related or they all relate to some complex and
involved situation which you need to include in the post for full
understanding.

 

[Bill Case]

Thanks Tom;

You, in particular, have been very helpful to me over the last month and I
want you to know I appreciate it.

You can ask programming questions here. Best to put each question in a
separate post unless they are related or they all relate to some complex and
involved situation which you need to include in the post for full
understanding.

I work a lot in Linux and use various Linux mailing lists. I have noticed a
couple of things on this MS mailing list I would like to ask about. There
doesn't seem to be any chattyness or friendly humour -- all business. If
that is the accepted style, I'll stop being casual myself.

No one ever seems to drift into OT (off topic). Although I agree one should
try to be relevant to the list purpose, on the Fedora mailing list, for
example, there was a great 250 post OT thread discussing the use of English
in programming that included particapants from around the world.

Not being critaical; just asking. 'When in Rome, do as the Romans do.'

Regards Bill

 

[Tom Ogilvy]

Your welcome

and as to other collections, mostly just your own, this article reveals some
good techniques:

http://www.j-walk.com/ss/excel/tips/tip47.htm
John Walkenbach's site.

 

[Jim Cone]

Re:"No one ever seems to drift into OT (off topic)." ...

Well not always; and never, ever mention Access and Excel in the same post.<g>
http://snipurl.com/wvbp
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Bill Case" <[email protected]>
wrote in message
Thanks Tom;
You, in particular, have been very helpful to me over the last month and I
want you to know I appreciate it.

You can ask programming questions here. Best to put each question in a
separate post unless they are related or they all relate to some complex and
involved situation which you need to include in the post for full
understanding.

I work a lot in Linux and use various Linux mailing lists. I have noticed a
couple of things on this MS mailing list I would like to ask about. There
doesn't seem to be any chattyness or friendly humour -- all business. If
that is the accepted style, I'll stop being casual myself.
No one ever seems to drift into OT (off topic). Although I agree one should
try to be relevant to the list purpose, on the Fedora mailing list, for
example, there was a great 250 post OT thread discussing the use of English
in programming that included particapants from around the world.
Not being critaical; just asking. 'When in Rome, do as the Romans do.'
Regards Bill