Take input and convert to use as a cell address

[amircse0711]

Hello Everyone,

I want to take the input of the line number from the user .

I want to run the operation from the cell range (A1:T100) (example)
Taken input from the user (1000) concated to T1000 (​

Cell = "T" & Uinput​

) and used it in the ​

Range("A1:Cell").Select

But getting error. Please see the screenshot for better understanding


​

https://imgur.com/jgESeda​

 

[gallen]

[FONT=Verdana]Range("A1:" & Cell).Select[/FONT]

 

[amircse0711]

Love You!!

Thank You