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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,114,367
Messages
5,547,499
Members
410,797
Latest member
mlfuson
Top