Macro to save file as cell value

[Nicola13]

Hi,

Looking to create a macro that will save as a cell value in my spreadsheet. Does anyone how to go about this?

[HaHoBe]

Hi, Nicola13,

something like this for the workbook holding the code:

Please Login or Register  to view this content.

Ciao,
Holger

[Nicola13]

Holger,

How can I adapt this to my workbook? The cell I want to use is F39. I am getting a 'Run-time error 9 Subscript out of range' for the following line

Please Login or Register  to view this content.

[HaHoBe]

Hi, Nicola13,

you need to adjust both the sheetname and the range. Letīs assume your sheet shows Nicola13 on the tab of the sheet:

Please Login or Register  to view this content.

If you want the code to work on every Worksheet in the workbook with the code you should go with

Please Login or Register  to view this content.

HTH
Holger