Consulting

Results 1 to 2 of 2

Thread: Field Issue

  1. #1
    VBAX Contributor
    Joined
    Jun 2014
    Posts
    107
    Location

    Field Issue

    I'm getting a weird issue that if I use a range or selection (xlObject.activesheet.cells(1,1) = selection.text) to place a paragraph that a has a reference to a table in it "Table 1-1" into an Excel cell it will change the value of the field to "Table 11" and will add some spaces at the end. If I delete a space (in Excel) it will delete a 1 (so I will now have "Table 1"). I assume that some of the ref. data is coming across but I can't see it. Is there way to get a paragraph without the corrupted field text value?

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Since you haven't posted any code, or attached a document/workbook, you're asking us to play a guessing game. I have better things to do with my time.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •