$$Excel-Macros$$ array sort issue

2010-11-08 Thread Ted
In an attempt to develop my own sort for an array, I seem to have run into a problem. I don't know what I 'm doing wrong specifically, but as soon as I attempt to invoke the Len Function, the whole thing breaks. subscript out of range error. I think I may be overthinking this, so any guidance is

Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Ted
ed. > > But your description sounded like you might want OTHER event macros > to continue to run. > > I guess I'll need a more detailed description for how you WANT it to work. > > Paul > > > > > > > > - Original Message > > From: Ted >

Re: $$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Ted
> then, within your event, check this status before running. > If (not ChangeFlag) Then Exit Sub > > hope this helps, > > Paul > > > > > > > > - Original Message > > From: Ted > > To: MS EXCEL AND VBA MACROS > > Sent: Mon, Novemb

$$Excel-Macros$$ $$Excel Macros$$ Worksheet_Change from Module

2010-11-01 Thread Ted
I use one book for portability of macros and I'd like to be able to turn on and off a worksheet_change macro from the book, not by adding the script to each individual worksheet. I can't find any information on this anywhere, so I thought this would be a good place to ask. All I can think of is w

$$Excel-Macros$$ New Member

2010-10-26 Thread Ted
Hi, just joined the group to take a look at what I could learn. I'll be posting any questions I have shortly. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://tw