+ Reply to Thread
Results 1 to 5 of 5

check entire column on a specific value and change it

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    brussels
    MS-Off Ver
    Excel 2003
    Posts
    63

    check entire column on a specific value and change it

    Hello there,

    I'm looking for VBA code to check entire column A in specific sheet "sheet3" on a specific value "SEC55B". If there is a value change it to "SEC550".

    Can somebody help me out please.

    Thnx a lot
    Aquila
    Last edited by Aquila; 07-08-2010 at 06:50 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: check entire column on a specific value and change it

    Record a macro.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-09-2010
    Location
    brussels
    MS-Off Ver
    Excel 2003
    Posts
    63

    Re: check entire column on a specific value and change it

    Quote Originally Posted by shg View Post
    Record a macro.
    Hello shg,

    it's not clear to me how to do this by recording a macro

    i do record => CNTR+F (the cel is now activated)
    then i go to the cell and change the value
    this is the code i have in VBA, looks not pretty good to run?

    Please Login or Register  to view this content.
    Some words to clear out would be appreciated

    Thnx
    Aquila

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: check entire column on a specific value and change it

    When I recorded a macro doing that, here's what I got:
    Please Login or Register  to view this content.
    ... which I would edit to this:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-09-2010
    Location
    brussels
    MS-Off Ver
    Excel 2003
    Posts
    63

    Re: check entire column on a specific value and change it

    Thnx a lot shg, probably i did something wrong

    Aquila

+ Reply to Thread

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