Insert Function in Excel 2002 (CopyOrigin field)

A

Aron V

I am trying to use the insert function in developing a VBA
application for Excel and I noticed the second parameter
to the Insert function in the new Office 2000. This
parameter would allow me (hopefully) to specify where to
copy the formats from when inserting some cells into my
worksheet. However when I use it like this:
wksTimesheet.Range("A" & lIndex & ":O" & lIndex).Insert
(xlShiftDown, xlFormatFromLeftOrAbove)
It doesn't seem to do anything different than when I use
it like this:
wksTimesheet.Range("A" & lIndex & ":O" & lIndex).Insert
(xlShiftDown)
Or without the second parameter. Has this feature been
implemented?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top