Thanks for trying guys, but neither of your solutions actually have the
desired result..

Gary"s student, your replacement line has the same end as my previous
attempts with the input box, the remainder of the macro does not complete.

Shane, whilst your macro completes ( I altered the directives to my file,
tab & cell reference) it does not covert the text cells to numbers.
p.s. I have found it a better solution to work from top right instead of
left as I include formula columns to the right of pasted data and need to
ensure that these are not valued in the process.

My workaround solution, although not ideal, is to simply sit on the starting
cell and run the unhide & hide personal macros then continue and it works ok.

Again, thanks for trying, it is obviously not as easy to code as I would
have thought.

"jo2109" wrote:

I have recorded the simple macro below but need to change the "F2" cell
address to be a user defined cell preferrably by 'clicking' on cell as I have
had no luck with coding the inputbox or goto...

Basically the macro unhides personal.xls, copies a cell (with 1 in it),
rehides the workbook and then should go to a starting cell, highlight range
and paste values..

Any assistance is greatly appreciated, thanks in advance.

Sub PasteMultipliedValue()
Application.Run "personal.xls!UnhidePersonal"
Range("E1").Select
Selection.Copy
Application.Run "personal.xls!HidePersonal"
Range("F2").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply, _
SkipBlanks:=True, Transpose:=False
End Sub