+ Reply to Thread
Results 1 to 6 of 6

Macro to compare 2 cells in different columns

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    267

    Macro to compare 2 cells in different columns

    HI gyus

    I'm strugling with one Macro, which should compare 2 cells in 2 different columns but it's actually doing nothing for unknown reason :-(

    Macro should the following:
    Loop throug the Column E and compare each cell from E3 untill Las row with each cell in columns G untill last row. Once is above, to go to AIT sheet and write "Point above the control limit " in column "D".

    Is there anybody whoc could help me with that? :-)
    Thanks,
    Andy


    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Macro to compare 2 cells in different columns

    Can you attach your file?

  3. #3
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    267

    Re: Macro to compare 2 cells in different columns

    Hi,

    attaching the data.

    Thanks,
    Andy :-)
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Macro to compare 2 cells in different columns

    Well, there are quiet few "typo" on your macro. For example, when you are doing the loop of For Int_First = 3 To Lng_Last, since you never assign a value to Lng_Last, the loop won't even start.

  5. #5
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    267

    Re: Macro to compare 2 cells in different columns

    Hi JieJenn,

    Could you please help me to correct those typos? I'm quite lost :-(

    Thanks, Andy

  6. #6
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    267

    Re: Macro to compare 2 cells in different columns

    Hi al,

    I sthere anybody who could help me? :-(

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Compare two columns and publish sheet name in case columns dont match
    By adaws in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2014, 01:21 PM
  2. [SOLVED] [Macro] Compare two columns, if cells differents, copy and delete cell
    By Skuz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2013, 06:08 PM
  3. [SOLVED] Macro to Compare Columns A & B and dispaly any duplicates in Columns C & D
    By robertguy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2013, 02:24 AM
  4. Macro compare cells and paste to columns
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-18-2013, 05:02 PM
  5. Macro to compare cells in different columns
    By katmison in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2009, 08:31 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1