Convert from a table to range

[571202]

Is it possible in the power query editor to convert a table to a range.

My source data must start as a table so I can't just convert that.

I have 20 sheets in the one workbook and I don't want to have to change them all to ranges individually.

Thanks in advance, cheers Cobber

 

[igold]

How about this...

Sub clrTbl()
    Dim wss As Object: Set wss = Worksheets
    Dim ws As Worksheet, tbl As ListObject
    For Each ws In wss
        For Each tbl In ws.ListObjects
            tbl.Unlist
        Next
    Next
End Sub

 

[571202]

Hi @igold Thanks for your quick answer.

That's a macro outside power query I assume. So I could use that but is there a way of converting from a table to a range in the power query editor?

Cheers, Cobber

 

[igold]

You're welcome. My bad for not noticing that it was a Power Query question. I am not fluent with the power query editor. Thanks for the feedback!

 

[571202]

No worries....if I don't get an answer I'll use your code, cheers.