Hi,
I want to create a query using power quering in Excel but I want to do it by using <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code only. I have the following:
Worksheets("Lista Trebuchet").Select
Dim lastrowtrebuchet As Long
lastrowtrebuchet = Range("A" & Rows.Count).End(xlUp).Row
Range("A1:T" & lastrowtrebuchet).Select
Selection.Resize(Selection.<wbr style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">Rows.Count + 10, Selection.Columns.Count + 0).Select
Now this is the selection I want to create the query out of, how do I do this using only <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code?
Thank you for your help!
I want to create a query using power quering in Excel but I want to do it by using <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code only. I have the following:
Worksheets("Lista Trebuchet").Select
Dim lastrowtrebuchet As Long
lastrowtrebuchet = Range("A" & Rows.Count).End(xlUp).Row
Range("A1:T" & lastrowtrebuchet).Select
Selection.Resize(Selection.<wbr style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">Rows.Count + 10, Selection.Columns.Count + 0).Select
Now this is the selection I want to create the query out of, how do I do this using only <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code?
Thank you for your help!