Forum

Hi Trond, What is not working? Sub test() Dim arr As Variant Dim i As Byte For i = 1 To 2 arr = Range(Cells(i, 1), Cells(i, 2)).Value MsgBox ar...

There are 1 D , 2 D, and multidimensional arrays, no doubt about this. If an array comes from a range, it will have 2 dimensions, even if you use 1...

Hi Simone, It makes sense, but not too much I'm afraid, mixing text with calculations is usually a bad choice. The difference can be calculated ...

You are using row context in 2 steps, #"Added Custom1" and #"Added Custom2". This operation is highly expensive in resource consumption, you have ...

You have to add a new column with this formula: =Excel.CurrentWorkbook(){[Name=[NamedRange]]}[Content][Column1]{0}

Hi Jacek, As mentioned, the cell that holds the path should be in a Table, not a regular cell. Select L1:L2 and press Ctrl+T to create a table. ...

Hi Trond, When you assign a range to an array, it will always have 2 dimensions (rows and columns) Use Arr=Sh.Range(....), not Set Arr=Sh.Range...

Can you upload the code you are using? Try archiving the text file.

Not sure what you expect me to do. I provided a detailed description of what you need to do, have you tried that? (the text file is still not do...

Hi Trond, The file download does not work, I can't see your code. But my guess is that it's not the For Next loop, if you use Do...Loop you will...

Hi Paul, You are looking for the code to change worbook calculation? Application.Calculation=xlCalculationManual Application.Calculation=xlCa...

Hi Lee, In one of the tables, simply add a new column with this formula that refers to the other table: =Table2QueryName The new column will ...

Add a new column with this formula (formula is in red): = Table.AddColumn(#"Added Custom", "Is Single Min", (rw)=> Table.RowCount(Table.SelectR...

Doesn't help, just brings more confusion. Remember, I know nothing about this game and its rules. You mentioned that " I have done birdies, now try...

Hi Andrew, A combo might be an easier alternative, but not the right way to go. To make your macro work, you have to extract the name based on t...