Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
TestCells = TESTXLS.Range("E:J") ColA = TestCells.Cut TestCells = TESTXLS.Range("F:K") ColA = TestCells.PasteIt cuts it and put it on clipboard bu it doesn't paste it. I get an error that the object does not exist.
This is from "Record a macro":
Range("A8").Select Selection.Copy <--- selection Range("D8").Select ActiveSheet.Paste <--- activesheet
Article ID: W16104
File Created: 2004:03:30:15:42:54
Last Updated: 2004:03:30:15:42:54