Cutting and Pasting a Cell in Excel
Keywords: Cutting and Pasting Cells Excel Range
Question:
I was just wondering how to do this. Is it possible w/o looping?I know how to copy and paste a cell using, e.g.,
zCells1=EAS.Cells(2, 1) zCells1.Value = "NAME: %cfile%"but how about a whole chunk at once!?Answer:
Try something like:ObjXL= ObjectOpen( "Excel.Application" ) ObjXL.Range("A1:D4")
Article ID: W14690Filename: Cutting and Pasting a Cell in Excel.txt