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 ([FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Cell = "T" & Uinput​

[/FONT]) and used it in the

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Range("A1:Cell").Select

But getting error. Please see the screenshot for better understanding


[/FONT] [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://imgur.com/jgESeda[/FONT]

 

[Special-K99]

No VBA expert.
Try

Range("A1:" & Cell).Select