I currently have the following code to copy values from one workbook to another. It copies from cells B1:B186.
In the case where I don't know how many cells I want to copy. How can I copy all cells until a blank cell is found?
Workbooks("Placeholder.xlsm").Sheets("Sheet1").Range("A1:A186").Value = Workbooks("Finances.xlsm").Sheets("Sheet1").Range("B1:B186").Value