PDA

View Full Version : Store selected ranges address in sheet



balumail75
11-23-2011, 05:32 AM
Hello All,

How to capture selected ranges addresses in a worksheet?

Thanks and Regards,
Balu

Bob Phillips
11-23-2011, 05:50 AM
Worksheets("Sheet2").Range("A1").Value = Worksheets("Sheet1").Range("H1").Address(,,,True)