Results 1 to 6 of 6

How to put the code in a for loop or simplifing the code

Threaded View

willy292 How to put the code in a for... 10-09-2013, 02:47 AM
Andy Pope Re: How to put the code in a... 10-09-2013, 03:55 AM
willy292 Re: How to put the code in a... 10-09-2013, 04:15 AM
Andy Pope Re: How to put the code in a... 10-09-2013, 04:22 AM
willy292 Re: How to put the code in a... 10-09-2013, 06:17 AM
Andy Pope Re: How to put the code in a... 10-09-2013, 06:34 AM
  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    China
    MS-Off Ver
    Excel 2007
    Posts
    8

    How to put the code in a for loop or simplifing the code

    Hi all,

    I dont want to paste eight time of the below code, is there any way to simplify the code
    Thanks a lot for all your attention

    For each column which is (D:K)

    DO
    Selection.TextToColumns Destination:=Range("D1"), DataType:=xlDelimited, _
            TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
            Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
            :=Array(1, 2), TrailingMinusNumbers:=True
    Moderator Note:

    Pls use code tags around your code next time as per forum rules.
    Last edited by Fotis1991; 10-09-2013 at 02:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Loop the code
    By mayurpatil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 04:05 PM
  2. Code to turn this code into a loop doing muliple copies
    By fbplaya02 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2013, 12:02 PM
  3. Loop Through Code
    By NoCanDo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2008, 08:28 AM
  4. [SOLVED] Help with better loop code
    By Sliman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2006, 01:52 PM
  5. [SOLVED] Help Simplifing Code
    By Joel Mills in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2005, 04:06 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