LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Value of Cell that is selected to Copy or Cut

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy selected part number of text from one cell into another cell orewa Excel Discussion (Misc queries) 1 April 11th 08 01:30 PM
one cell contains selected criteria, then copy the row ? gcouch Excel Discussion (Misc queries) 6 November 23rd 07 12:46 AM
excel: if selected, copy cell from corresponding row davey-in-the-navy Excel Worksheet Functions 1 October 7th 07 12:09 PM
copy selected cell brian thompson3001 via OfficeKB.com Excel Programming 1 August 24th 06 01:39 PM
Copy selected cell in column and fill in blanks Bluestar Excel Programming 2 June 15th 05 03:28 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"