ExcelBanter - Copying text from a shap

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copying text from a shap (https://www.excelbanter.com/excel-discussion-misc-queries/76432-copying-text-shap.html)

Copying text from a shap

Hi All,

Is there any way I can copy the text from a shape in a worksheet to a
cell on the same worksheet?
Im looking for a formula, a macro would be last resort.

Thanx in advance..

All times are GMT +1. The time now is 02:25 AM.