PDA

View Full Version : Field Issue



heedaf
06-02-2020, 04:23 PM
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?

macropod
06-02-2020, 07:09 PM
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.