Thanks
From: Daniel <dcolarde...@free.fr> To: excel-macros@googlegroups.com Sent: Monday, September 5, 2011 5:39 AM Subject: RE: $$Excel-Macros$$ Doesn't this mean? You have to write [C32] and [C33] (or Range(“C32”), Range(“C33”)). C32 is considered a variable name, not a range. HTH Daniel De :excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de David Lanne Envoyé : lundi 5 septembre 2011 07:06 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Doesn't this mean? Sub OTX() ' ' OTX Macro ' ' If (c32 <> c33) Then End If If (c32 = c33) Then Range("g32:g33").Select Application.Run "OT" End If End Sub Doesn't this mean if c32 doesn't equal c33 nothing happens,if c32 equals c33 then it runs "OT". Right now it runs "OT" whether c32/c33 are equal or not. Thanks, David Lanne -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel