I text box returns a string and you need a number

from
Range(Cells(myvar, 16), Cells(myvar, 22)).Select
Selection.Copy
to
Range(Cells(val(myvar), "P"), Cells(val(myvar), "V")).Select
Selection.Copy
"Allan" wrote:

I need to get the row number from a sheet by using an input box
type = 8 ?
Once I have the row it will be used to copy selected columns to another sheet.

Right now I' using this:

Sheets("Tickler").Select
myvar = Application.InputBox("Enter Line number to retrieve Row", "OPTIONS", _
Type:=1)

Range(Cells(myvar, 16), Cells(myvar, 22)).Select
Selection.Copy
...
AH