View Single Post
  #1   Report Post  
Ed
 
Posts: n/a
Default 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