naming a dynamic range and using it in power query

[Baariees]

I have a sheet in which there would be a dynamic range with static columns and dynamic rows,

Range("A1:Y1892").Select **(need this range to be dynamic, which can be furthure used in power query)
Range("J19").Activate
Application.CutCopyMode = False
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$Y$1892"), , xlYes).Name = _
"Table1"
Range("Table1[#All]").Select
ActiveWorkbook.QUERIES.Add Name:="Table1", Formula:= _



Please anyone could help me with this, thanks in advance for your help.