choosing worksheets in VB code?
Posted by Ben on April 17, 2000 3:50 AM
In a VB procedure, I want to be able to activate a worksheet amongst about 10 in the workbook which is usually called "Vendor Total Bef Exch", but may be called anything along those lines eg: "vendor tot bef exch"; "Vendor Total Before Exchange" etc. Capitalisation isn't a problem, but the slight differences in names means I can't refer to it directly I think.
I have done a small form which lists all the worksheets in the book for the user to select, but was wondering if there was a better way using string comparisons that anyone could think of.