Copying text between tables using VBA
I'm trying to make sure a group of tables all have the same headers. So
after formatting one table, I'm copying all the pertinent attribute over in
a macro. The text, though, is giving me a bit of a problem - an extra
paragraph mark. I'm using
tab2.Cell(1, 1).Range.Text = tab1.Cell(1, 1).Range.Text
and always get the text plus a paragraph mark. Any suggestions that would
save me from going back to every table and deleting the paragraph mark?
Ed
|