Thanks
From: NOORAIN ANSARI <noorain.ans...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Monday, September 5, 2011 3:00 AM
Subject: Re: $$Excel-Macros$$ Re: Doesn't this mean?
Dear David,
Pls try it..........
Sub Example()
If Sheet1.Range("C32").Value = Sheet1.Range("C33").Value Then
Sheet1.Range("g32:g33").Select
Application.Run "OT"
Else
Exit Sub
end if
End Sub
--
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Mon, Sep 5, 2011 at 12:17 PM, lifescholar <steve.ja...@lifescholar.net>
wrote:
If (Range("c32") <> Range("c33")) Then
>
>On Sep 5, 6:06 am, David Lanne <djl99_28...@yahoo.com> wrote:
>> 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
