copy paste macro

[bsd9197]

Trying to create a macro that will copy from cell A3 which I've ranged named "Input Cell" and then paste the value of whatever is in "Input Cell" into the cell where the cursor is located.

Any assistance would be greatly appreciated!

Thanks,
bsd9197

 

[Joe4]

You don't even need to name the cell "My Input Cell". You could just do:

Sub MyCopyPaste()

    ActiveCell.Value = Range("A3").Value

End Sub

 

[Mudface]

Try: -

Public Sub CopyData()

ActiveCell.Value = Range("Input_Cell").Value

End Sub

Edit: J Miskey- your code wouldn't work as intended on a different worksheet to the named cell :wink:

 

[bsd9197]

It worked!!

Thank you very much!!

 

[Joe4]

Mudface,

True. I was working under the assumption that it was on the same spreadsheet (that is what I thought the original question implied), but probably shouldn't have made that assumption.