modify an embedded EXCEL object (OLEObject) in VBA

myspacee

New Member
Joined
May 18, 2005
Messages
25
hello,
i've an embedded EXCEL object (OLEObject)
in my sheet1. Can i enter in the object, copy
values and paste in my sheet1?

Sorry for bad english, and many thanks for help !!




Andrea
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
If you have used Edit/PasteSpecial .. Paste Link then changes in one sheet will reflect in the other. No special code is needed.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,088
Messages
5,570,144
Members
412,306
Latest member
fabio6
Top