Copy a TextBox (shape)
OssieMac -
Thank you, Mark
"OssieMac" wrote:
Hi Mark,
I haven't been able to do this without actually activating the 2nd workbook
and worksheet and selecting the paste location. However, here is what I have
that works but maybe someone else can do it better.
Windows("Book1").Activate
Sheets("Sheet1").Shapes("TextBox1").Copy
Windows("Book4").Activate
Sheets("Sheet2").Activate
Range("B8").Select
ActiveSheet.Paste
--
Regards,
OssieMac
"Mark" wrote:
Hi -
I am working in C# VSTO and Excel 2007 but thought I'd ask how to do this in
VBA and maybe it would help with the C# code.
I just want to copy a shape (textbox) with all of its text and formating
(e.g., Bold, no fill, no line). And paste it multiple times down the page
(via a loop), actually to a different workbook.
I've tried shape.copy but don't know how to paste it where I want it.
I've tried shape.duplicate but can't get that to work either.
Much thanks for ideas.
Mark
|