View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Value of Cell that is selected to Copy or Cut

Hi,

You mention the selection change event so I guess your using that and in
that case

Target.value

will give the value of the cell that called the event

Mike

"GCRDelphi" wrote:

I wasnt to know how to get the value when SelectionChange fires and
CutCopyMode is Cut of the cell that is going to be cut and the cell it self.
For example:

(the following is not code)
Selects C5 = 10
Cut
Selects D10
[Selection Change Fires]
If CutCopyMode = xlCut Then
If "Copied Cell Value" < 10 Then CutCopyMode = False
.
.
.

How can I get "Copied Cel Value"?

Thank you for your help.

--
Gabriel Camarena R.
Delphi Tijuana IT Support