Results 1 to 10 of 10

Complex Loop Pipe-Delimited Data Export

Threaded View

  1. #10
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Complex Loop Pipe-Delimited Data Export

    I don't think you can have a leading minus in the first cell.
    Before
    Offset = -.Cells(1, 8) + .Cells(1, B)
    After
    Offset = .Cells(1, 8) + .Cells(1, B)

    Or is that suppose to be
    Offset = 1 -.Cells(1, 8) + .Cells(1, B)
    Last edited by Tinbendr; 01-28-2016 at 04:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Field Data pipe delimited with many fields inside
    By ginjack in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2015, 04:35 PM
  2. Converting Pipe Delimited Data String into Seperate columns using VBA Macro
    By mikey42979 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2014, 03:15 PM
  3. [SOLVED] Pipe delimited vs comma delimited problem
    By theletterh in forum Excel General
    Replies: 4
    Last Post: 01-23-2013, 07:27 PM
  4. [SOLVED] Concatenating cells where one contains Pipe delimited data
    By Acedge in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2012, 12:25 PM
  5. Export worksheets from multiple workbooks into pipe delimited txts
    By anshul03 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2012, 05:16 AM
  6. Export Multiple Tabs to Pipe Delimited Txt
    By Machie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2010, 08:32 PM
  7. [SOLVED] How can I convert tab delimited files to pipe delimited?
    By Jeremy Town in forum Excel General
    Replies: 1
    Last Post: 01-23-2006, 11:10 AM

Tags for this Thread

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