Re: $$Excel-Macros$$ Re: Find negative and terminate

This works perfectly. Thanks, Anoop. Richard -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread t

$$Excel-Macros$$ Re: Find negative and terminate

Here's a simple example attached. On Wednesday, February 20, 2013 7:33:47 PM UTC-5, Richard Bridges wrote: > > Hi guys, > > I'd appreciate help with this one, can't quite figure it out. I need to > search all worksheets in a workbook for a negative number in

$$Excel-Macros$$ Find negative and terminate

Hi guys, I'd appreciate help with this one, can't quite figure it out. I need to search all worksheets in a workbook for a negative number in column K, display a msgbox showing the cell addresses of the negative cells, and to exit the macro if a negative number is found. This is probably gibb

Re: $$Excel-Macros$$ Need help with a couple subs

Thanks for the help, Ashish. I'll play around with it and see if I can get it to work for me. Richard > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

$$Excel-Macros$$ Need help with a couple subs

Hi guys, I'm having trouble writing a couple subs. I'm new to vba, so what I'm asking for may be very complicated. If so, I apologize. I've attached a sample .xslm file which I'll be referencing throughout this post. So what I'm trying to do is use the workbook as a tool to simplify orderin