blakeobeans
08-01-2012, 05:17 PM
Office 2010, Windows 7
I'm trying to copy a cell from Excel to Word and align it in the center of the word document using VBA. I'm very particular with retaining the paste special type in order to remain consistency with the larger project. Below is the code that I'm using:
Activecell.Select
Selection.Copy
wdApp.Visible = True
wdApp.Selection.PasteSpecial Link:=False, DataType:=1, Placement:=wdInLine, DisplayAsIcon:=False
I suppose there are many ways to do this, but I can't figure out a single one!
Thanks,
Blake
I'm trying to copy a cell from Excel to Word and align it in the center of the word document using VBA. I'm very particular with retaining the paste special type in order to remain consistency with the larger project. Below is the code that I'm using:
Activecell.Select
Selection.Copy
wdApp.Visible = True
wdApp.Selection.PasteSpecial Link:=False, DataType:=1, Placement:=wdInLine, DisplayAsIcon:=False
I suppose there are many ways to do this, but I can't figure out a single one!
Thanks,
Blake