Thread: Can you get excel range object off the clipboard?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
LFCFan[_7_] LFCFan[_7_] is offline
external usenet poster
  
Posts: 1
Default Can you get excel range object off the clipboard?

Hi Brady,

Could you not pass the cell's address to the clipboard?

Set cData = New DataObject
cData.SetText (ActiveCell.Address)
cData.PutInClipboard

Not sure if this is what you mean?

HTH
Joe


--
LFCFan
------------------------------------------------------------------------
LFCFan's Profile: http://www.excelforum.com/member.php...o&userid=37484
View this thread: http://www.excelforum.com/showthread...hreadid=572635

Reply With QuoteReply With Quote