Results 1 to 4 of 4

Thread: Loop and Check For Values In Entire Column in Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-01-2012, 09:29 PM #1
    Jeff5019
    Jeff5019 is offline
    Junior Member
    Join Date
    May 2012
    Posts
    1
    Rep Power
    0

    Post Loop and Check For Values In Entire Column in Excel

    I need this to check every cell in these columns. Not just the cells in row 2. Any assistance would be greatly appreciated.


    Code:
    If Sheets("RSL").Range("M2") = Sheets("FailedSpots").Range("L2") Then

    If Sheets("RSL").Range("K2") > Sheets("FailedSpots").Range("M2") Then
    
        Sheets("RSL").Range("K2").Value = Sheets("FailedSpots").Range("M2").Value
        
    End If
    
End If
    Last edited by Admin; 05-01-2012 at 10:15 PM. Reason: code tag added
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delete Entire Row For All Empty Cells In Column
    By johnreid7477 in forum Excel Help
    Replies: 4
    Last Post: 06-15-2013, 05:50 AM
  2. VBA Code To Loop Cells In A Column One By One And Search In Another Sheet
    By naseerrahaman in forum Excel Help
    Replies: 1
    Last Post: 06-12-2013, 07:42 PM
  3. Vlookup Multiple Values By Adding Formula With Loop In VBA
    By Safal Shrestha in forum Excel Help
    Replies: 15
    Last Post: 04-22-2013, 04:49 PM
  4. Loop to two columns and Concatenate values
    By ivandgreat in forum Excel Help
    Replies: 15
    Last Post: 04-14-2013, 08:20 PM
  5. Macro to check values based on certain text
    By Howardc in forum Excel Help
    Replies: 25
    Last Post: 11-05-2012, 09:03 PM

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
  •  

Forum Rules