I can use this code;

ActiveSheet.UsedRange.Cells.Select
MsgBox ActiveSheet.UsedRange.Cells.Address

and the message gives $A$1:$E$8 - which is correct

Can I parse out (or programatically get) the Start ($A$1) and End ($E$8)
Address values ?

How would I (for instance) Set a Range to those values ?

Can I further parse out the actual Row/Column Elements (giving me 4 seperate
values) so I could reconstruct a new Range with calculated & actual values ?

Not used to working with vba too much so trying to get a grip on how things
work.

Thanks for any help