Is there anyway I can automatically insert text into a macro by referencing
the worksheet and cell where the text can be found? I have done it in some
cases as part of other text in a line in the macro using " &
Sheets("Customize").Range("L45").Value & " but have not been able to figure
out how to insert a whole line. I currently build macros using excel formulas
based on answers to questions (i.e., if the answers is "yes" to the
questions, "Do you want to update links and Do you want to open the file
Read-Only?", my formula produces the text "UpdateLinks:=3, ReadOnly:=True" in
cell L45 of worksheet "Customize" but I still have to manually copy and paste
that into the macro. Thanks.