Results 1 to 5 of 5

Condition and function to write number value greater than a specific number

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    19

    Question Condition and function to write number value greater than a specific number

    Hi Friends,

    I am new to VBA and need help regarding one condition.
    How can I write to check if the value in a specific cell is more than 4000 or not and whether the value is a number or not.

    This is what I have written write now.

    #
    Dim col1 As Long
    col1 = 1
    If InStr(1, Worksheets("Albany_MA").Cells(i, col1).Value, "4") Then
    I understand what I have written checks for # 4 and not for a number greater than 4000. Please advice.

    Thanks
    Jay
    Last edited by arlu1201; 11-12-2012 at 06:38 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1