The below code doesn’t work on the 4th line. If some one can help.
I would like to use the information from the input box to feed in to the VBA code.
if the msg box says b25, I would want it copy the data from b25 and paste it in another sheet as shown below.
input_Cells = InputBox("Input column") MsgBox "Want to Continue?", vbYesNoCancel input_Celli = InputBox("Input row number") ActiveSheet.Range("'input_Cells' & 'input_Celli'").Copy Worksheets("ACV").Activate Range("G36").PasteSpecial xlPasteValues