Gord Dibben used his keyboard to write :
Thanks.
I set my pesky XL11 TaskPane disabled so I never see it.
Gord
On Mon, 16 Apr 2012 18:29:34 -0400, GS wrote:
Just to clarify...
I usually use InsertShift at the target location and drag-n-drop the
data. (I probably do this to avoid CutCopyMode and/or putting stuff on
the Clipboard so that pesky TaskPane doesn't display in XL11!<g)
Thus, I only use Cut for moving cols/rows around.
Yeah, that's an option I never thought of but since I'm used to using
InsertShift I'll just carry on with that practice. Not really sure why
I never tried doing it via CutInsertCutCellsShift other than avoiding
the clipboard, but it's a habit I got into that I don't mind
persisting.<g
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion