bruderbell
Active Member
- Joined
- Aug 29, 2006
- Messages
- 374
Hi, I've tried searching the board, but didn't find what I'm looking for.
What I'm trying to do is this:
I want the macro to paste the cell reference (C6, for example) of the currently highlighted cell into an already existing formula in a different cell. Basically, I want it to tag the cell reference onto the end of the current cell text of the 2nd cell. I know how to get the proper cells selected and such, and I know how to do copy-paste stuff. But there doesn't appear to be a special paste that will paste the cell reference. And even more difficult looking is the prospect of tagging this copied info onto the end of the 2nd cell.
Any help?
What I'm trying to do is this:
I want the macro to paste the cell reference (C6, for example) of the currently highlighted cell into an already existing formula in a different cell. Basically, I want it to tag the cell reference onto the end of the current cell text of the 2nd cell. I know how to get the proper cells selected and such, and I know how to do copy-paste stuff. But there doesn't appear to be a special paste that will paste the cell reference. And even more difficult looking is the prospect of tagging this copied info onto the end of the 2nd cell.
Any help?