Copy a cell reference and paste

[siukingyiu]

I want to create a macro which allows me to copy the current reference location (e.g. Cell B3).

And paste into another cell with the formula (=B3) composed by the previous location copied


Thank you!

[AndyLitch]

If you want to duplicate values from the selected cell to another, the VBA syntax is :

Please Login or Register  to view this content.