Power Query tables in VBA

Hi Everyone,

I have a table generated by Power query and in my VBA I have below code which is trying to refer "header row".

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

I tried both codes, but VBA is taking my second row instead of header. When I apply same code to a normal excel sheet which is not a table data, both codes is working perfectly.

PS: The result of this macro is copy pasting some data to another excel sheet. So if its table macro is pasting second row. If its not table macro is pasting first row.)

Do you know what is the reason and what would be a solution for this ?


Thank you very much
Orhan

Orhan

This works for me to select the header row of a table generated with Power Query.

Please Login or Register  to view this content.

Originally Posted by Norie

Orhan

This works for me to select the header row of a table generated with Power Query.

Please Login or Register  to view this content.

Thank you Norie. But unfortunately, it didnt help still. I am sharing my all code below. Maybe if I kindly ask to review it, you can find the cause ?

Basically, I have two range as header and source. And I am pointing for header the Range(Cells(1,1)) and for source I am pointing Range(Cell(2,1)), but some how VBA is pasting second row as header to the new file

And if I change my Sheet1 with a non-table data. It is working. But I need to adjust this for table, since my source will be a power query.

Please Login or Register  to view this content.