Hi, Graham. Thank you for the info and update. I'm seeing an anomaly when running the new macro; perhaps I have misunderstood something.
I have provided an attachment with a 4-cell table, cells left-aligned, with spaces preceding the numbers. With my cursor in the top left cell, or with all cells' content selected, only the second row is affected.
Also, two other things:
The macro seems to indicate the creation of a decimal tab, but since I don't know VBA, perhaps that's my misreading. It doesn't create one in any case, perhaps due to the variable column-width issue being addressed.
And this, just my ignorance, out of curiosity I tried changing the 20 you used for right cell pad to 80, but it appeared to have no effect.
Again, I genuinely appreciate the top-level expertise I receive here. I don;t mean to take undue advantage of it with these questions.
|