Is it possible to get a formula into the clipboard so that a pastespecial VBA
command can paste it into a cell or range of cells? If so what is the VBA
line code and format to set it? Also is it possible to retrieve the name of
the sheet/book so that a macro will run in the current book as opposed to the
book it was created in?