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
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