I'm now confused, where does CTRL+X come into it your posting in programming!!

Select Cell "X"
Ctrl+X
Select Cell "Y"

The 3 lines of your desciption above, when you select cell "X" and copy it,
it's the active cell and therefore

activecell.value works

There's no need to do any selecting at all, unless your using random numbers
to pick your range to copy you must know where it is and can test the value
with any of the methods I gave you.

Mike

Mike

"GCRDelphi" wrote:

Sorry, but ActiveCell.Value gives me the Value of the Cell being selected not
the cell that I had intially used "cut" on and the others are for a Specific
Cell not any Cell I cut from. Let me repeat:

Select Cell "X"
Ctrl+X
Select Cell "Y"
Find out what the value of Cell "X" is to verify it can be placed in Cell "Y"

Target.Value = Value of Cell "Y"
ActiveCell.Value = Value of Cell "Y"

I need Value of Cell "X"

Thank you for your input.
--
Gabriel Camarena R.
Delphi Tijuana IT Support