+ Reply to Thread
Results 1 to 3 of 3

simplify vba code

  1. #1
    Registered User
    Join Date
    12-28-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    54

    simplify vba code

    Hello,

    Is there a way to simplify this vba code to work on all the 'x' in Cell L?

    Please Login or Register  to view this content.
    Attached is my sample excel sheet to work it on. Basically I want what the above coding does to one cell to go through, find all the x's in Cell L and cut and paste Cells E-O and move them down to the matching cell D.

    CheerZ!
    Wyldjokre69

    Sample11062014.xlsb

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: simplify vba code

    hi wyldjokre69, I might be wrong but I hope I'm right. The code is not simplified. Please check attachment, press "Run" button or run code "test"
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-28-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    54

    Re: simplify vba code

    Thank you so much watersev, it worked beautifully. Closing thread.

    CheerZ!
    Wyldjokre69

    This is an awesome piece of coding:

    Please Login or Register  to view this content.
    Last edited by wyldjokre69; 06-11-2014 at 10:04 AM. Reason: need to add coding

+ 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. [SOLVED] Simplify VBA Code
    By Sky188 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2012, 02:31 PM
  2. [SOLVED] How can I simplify this code?
    By etuckram in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2012, 05:04 AM
  3. Simplify my Code
    By wrathastorm in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 04-26-2012, 02:23 PM
  4. simplify code
    By double a enterprises in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2010, 05:42 AM
  5. Need to simplify code
    By alexwren in forum Excel General
    Replies: 7
    Last Post: 08-15-2006, 03:07 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