Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Not Equal Operator

  1. #1
    Join Date
    1st July 2004
    Posts
    23

    Not Equal Operator

    Hi All (Again!),

    I would like to know how to program "not equal" in a VB Macro. I want to set up a statement like so:

    If Cells(y,2) NOTEQUAL "35" Then
    and so on...

    I have looked through a lot of material and have not come across this. Is there anyway to do so?

    Thank you always!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th July 2004
    Posts
    31
    I was thrown off by the not equal as well, I was used to != being the operator but here in VB it is "<>"

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    1st July 2004
    Posts
    23
    Great! Thank you mucho!!! haha!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Query With <> Operator
    By Ktrasler in forum Excel and/or Access Help
    Replies: 2
    Last Post: September 4th, 2007, 22:50
  2. Values Which Are Equal Not Treated Equal
    By hollydog in forum EXCEL HELP
    Replies: 2
    Last Post: July 6th, 2007, 01:08
  3. <> operator
    By flee01 in forum EXCEL HELP
    Replies: 2
    Last Post: June 21st, 2006, 06:45
  4. bitwise And operator with Double
    By Goppi in forum EXCEL HELP
    Replies: 10
    Last Post: December 20th, 2005, 07:33
  5. Index Match using < operator
    By Neiluk66 in forum EXCEL HELP
    Replies: 5
    Last Post: February 11th, 2005, 05:09

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno