Results 1 to 8 of 8

Syntax - Text To Column

Threaded View

The Skipper Syntax - Text To Column 07-29-2013, 04:33 PM
AlphaFrog Re: Syntax - Text To Column 07-29-2013, 04:42 PM
The Skipper Re: Syntax - Text To Column 07-29-2013, 04:52 PM
AlphaFrog Re: Syntax - Text To Column 07-29-2013, 05:28 PM
Solus Rankin Re: Syntax - Text To Column 07-29-2013, 05:05 PM
Norie Re: Syntax - Text To Column 07-29-2013, 05:31 PM
The Skipper Re: Syntax - Text To Column 07-29-2013, 05:48 PM
The Skipper Re: Syntax - Text To Column 07-29-2013, 06:10 PM
  1. #1
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Syntax - Text To Column

    Below is the Text To Column section of a macro I recorded. I do not understand the "Array" syntax and would sure appreciate a helping hand. Thanks !!

    Selection.TextToColumns Destination:=ActiveCell, DataType:=xlFixedWidth, _
            OtherChar:="-", FieldInfo:=Array(Array(10, 19), Array(4, 1), Array(7, 9), Array(8, 1 _
            ), Array(16, 9), Array(24, 9), Array(32, 1)), TrailingMinusNumbers:=True
    Last edited by The Skipper; 07-29-2013 at 06:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Syntax for Using Range with a Variable Column
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2013, 12:36 PM
  2. syntax for deleting text 0 from string
    By surfengine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2010, 04:50 PM
  3. Row / column selection syntax
    By jayron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2008, 04:46 PM
  4. [SOLVED] Count Text Syntax
    By nastech in forum Excel General
    Replies: 0
    Last Post: 03-22-2006, 03:50 AM
  5. Range of a whole column in Cells syntax
    By Hal Styli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2005, 03: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