naming a dynamic range and using it in power query

Baariees

New Member
Joined
Oct 12, 2020
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,114,232
Messages
5,546,643
Members
410,752
Latest member
MC01_
Top