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

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.

--
Regards,
Tom Ogilvy


"Bill Case" wrote:

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

Thanks Tom;

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

"Tom Ogilvy" wrote:

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

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.
--
Regards,
Tom Ogilvy

"Bill Case" wrote:

Thanks Tom;

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

"Tom Ogilvy" wrote:

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

"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"
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.
"Tom Ogilvy" wrote:

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