Hi all,

1) A macro works on a worksheet with a variable number of rows R.
In column A, cell A2 is filled with some text. I need all cells from
A3 to A(R) to be filled the same.

2) The macro is stored in a book and works on another one. At the end,
I need the "object" book to be Saved As.... with a different name. So
I did:

ActiveWorkbook.SaveAs Filename:="MYNEWFILE.xls", FileFormat:=xlNormal

For some reason I don't know, the file is saved under \My Documents,
instead the "working" folder (meaning the directory where both books
are).

thanks for help