The attached macro is designed to return the addresses of whatever cells are selected by the user.
This works perfectly. But what I am struggling to do is to use the retuned addresses in the formula bar of cell C12 so that all addresses are added together.Please Login or Register to view this content.
Cell Picker.png
Note: I am not looking for the macro itself to summate the cell contents, just to populate the formula bar of the 'Total' cell C12 with the addresses (separated with + symbols)...
...as this will allow the user to click on C12 to review what has been selected using the standard excel formula review coloured boxes (like below). I am also attaching the stripped back file for anyone who could help. Thanks!
fx.png
Bookmarks