determining the cutcopy range progamatically
It would be the selection. You can use the address property. I don't have
excel running right now but it would be one of the following
SelAddress = selection.address
or
SelAddress = activecell.address
Make sure if it is in a different sheet or workbook that you include these
in the code.
I sometimes define the cut or copy Range like this
Set CopyRange = Workbooks("Book1.xls").sheets("Sheet1").Range("A10 :C100")
Set PasteRange = Workbooks("Book2.xls").sheets("Sheet3").Range("D10 ")
CopyRange.Copy Destination:=PasteRange
CopyAddr = CopyRange.Address
PasteAddr = PasteRange.Address
"jc" wrote:
is there a way to determine progamattically the range that is highlited with
a marquee while in cut or copy mode?
--
JC
|