Selecting cells within a named column

[JMK326]

Every time this macro is being used, the data comes from a different column but always on the same rows. I set FY13column to the user selected column but I can't figure out how to copy specific cells from within that column.

Here is what I have that is not working:
Set FY13column = Application.InputBox(prompt:="Select the column that contains the FY13 current month data", Type:=8)
Sheets("Current Month Data").Range("E5").Copy Sheets("Month to Month").Cells(FY13column, 36)

 

[RickXL]

Try this instead:

FY13column = Application.InputBox(prompt:="Select", Type:=1)
Sheets("Month to Month").Cells(36, FY13column).Value = Sheets("Current Month Data").Range("E5").Value

The prompt type is now 1 so it is expecting a number not a cell reference like "Sheet1!A1".
The rows and columns in Cells has been swapped round.
I changed, possible unnecessarily, the COPY command to a straight assignment