Steve Turner
sturner at mseco.com
Thu Jun 26 09:05:15 CDT 2008
Thanks Darryl, I'll look at them. I should have taken the time to get more familiar with Excel VBA years ago but it takes time I don't have sometimes. I learned lotus macros years ago and still use some today because they are simple and can do things easier for me. What's a pain in Excel is that sometimes I have a macro in one sheet that doesn't work in another like the Do while loop I was using. My old brain is suffering from information overload. Every time I put something in something goes out. Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Wednesday, June 25, 2008 7:45 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Do While in VBA If any of you have Excel issues, I highly recommend one of the Excel lists here. I have been subbed to both for years. L list is for Developer type issues http://peach.ease.lsoft.com/archives/excel-l.html G list is for more mundane Excel stuff. http://peach.ease.lsoft.com/archives/excel-g.html Both lists are very friendly and full of MVP types who really know their stuff. Also lots of fun like AccessD, and of course, free to sub and unsub. hth Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve Turner Sent: Thursday, 26 June 2008 1:55 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Do While in VBA SO simple thanks Rocky, none of the example's in the book or code had that simple phrase just End Sub after the loop phrase. I've sent emails to two excel groups trying to find this answer and none replied. Access d Is the greatest. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Wednesday, June 25, 2008 10:42 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Do While in VBA If Cell has 'something' then Exit Do? Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Turner Sent: Wednesday, June 25, 2008 8:31 AM To: Access Developers discussion and problem solving Subject: [AccessD] Do While in VBA Hello, Quick question I know someone can help with. I have a VBA macro in Excel I'm working on with a Do While loop in it. I want it to stop on a cell I put something in to make it stop. Right now it just bypasses what ever I put in the cell. Its puzzling why. Can't use the "" blank cell because the macro is deleting blank rows. Declared a string var but what I put in it may be somehow different than what shows up in the cell by some small amount like Stop, "Stop" tried both but it didn't work. Using Dim dontdo$ dontdo = "Stop" x = ActiveCell.Row Do While ActiveCell(x, 1).Value <> dontdo. Steve A. Turner Controller Mid-South Engineering Co. Inc P.O. Box 1399 Hot Springs, AR 71902 E-Mail: sturner at mseco.com and saturner at mseco.com Phone:(501)321-2276 Fax: (501)321-4750 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com