Dynamic File Names

[guyKn]

I have a worksheet that changes - Each time there is change I want to use a macro to save the file using a name in a cell on the worksheet. - Can you help?

GK

 

[dyarwood]

Try using the following

filenam = Cell(i,j).Value
ActiveWorkbook.SaveAs Filename:= filnam

i is the row number of the cell and j is the column. The Name of the file is held within the Cell at i ,j. Think this should work
Let me know

dyarwood

 

[guyKn]

Hi,

Thanks, however the 'cell' bit is not recognised - Keep getting the error message sub or function not defined

Any Ideas?

GK

 

[dyarwood]

Sorry I keep doing this in my macros. Its supposed to be Cells not Cell.

dyarwood

 

[guyKn]

Hi,

Cheers - Works

GK