Re: Possible to move data to a specific cell?
From: Mcasteel (Mcasteel.1erkxe_at_excelforum-nospam.com)
Date: 10/27/04
- Next message: Myrna Larson: "Re: Count rows based on multiple variables"
- Previous message: mudraker: "Re: How to get Cell value and use as file name in macro"
- In reply to: Belle: "Possible to move data to a specific cell?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 21:45:27 -0500
I believe you could copy the entire row and move it to row x.
I have a book at work that shows how to do this... but I hope the idea
helps.
its something to the effect of:
activecell.range("F").copy
activecell.range("X").paste
(mybe you could even cut, or else after you copy, just delete the
entire column?)
Does anyone think this method would work for Belle
-- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15698 View this thread: http://www.excelforum.com/showthread.php?threadid=272517
- Next message: Myrna Larson: "Re: Count rows based on multiple variables"
- Previous message: mudraker: "Re: How to get Cell value and use as file name in macro"
- In reply to: Belle: "Possible to move data to a specific cell?"
- Messages sorted by: [ date ] [ thread ]
