Re: Possible to move data to a specific cell?
From: Chris Shipley (dizzyqwerty_at_mtsqwerty.net)
Date: 10/27/04
- Next message: Don: "Re: Count rows based on multiple variables"
- Previous message: Dave Peterson: "Re: Open Locked Columns to view code?"
- In reply to: Belle: "Possible to move data to a specific cell?"
- Next in thread: Mcasteel: "Re: Possible to move data to a specific cell?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 21:22:10 -0500
Would something like this work?
FirstRow = 5
LastRow = 15
SourceColumn = 2
DestColumn = 9
For CurrentRow = FirstRow To LastRow
Cells(CurrentRow, SourceColumn).Copy
Cells(CurrentRow, DestColumn).PasteSpecial xlPasteValues,
xlPasteSpecialOperationNone
Next 'CurrentRow
HTH
Chris
"Belle" <Belle.1eqvxb@excelforum-nospam.com> wrote in message
news:Belle.1eqvxb@excelforum-nospam.com...
>
> I have a spread*** with data pulled from my database. I want to take
> the value in the last cell of each row and move it into a new cell, one
> that I specify.
> In other words, for each row, take the data in the last column and move
> it to column X, same row. The column to move to will be the same for the
> entire ***.
>
>
> --
> Belle
> ------------------------------------------------------------------------
> Belle's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=15736
> View this thread: http://www.excelforum.com/showthread.php?threadid=272517
>
- Next message: Don: "Re: Count rows based on multiple variables"
- Previous message: Dave Peterson: "Re: Open Locked Columns to view code?"
- In reply to: Belle: "Possible to move data to a specific cell?"
- Next in thread: Mcasteel: "Re: Possible to move data to a specific cell?"
- Messages sorted by: [ date ] [ thread ]
