My code follows:

Dim BondColumn As Range

Set BondColumn = Workbooks("Bond Calculator.xlsm").Sheets("Bond Table").Cells(1, 1).EntireColumn
BondColumn.Select ' tester
Exit Sub ' tester
When I Run the code I thought it was supposed to highlight the entire column A, but instead it highlights columns A to F which consists of my entire table.

But when i try using .EntireRow like this:

Dim BondColumn As Range

Set BondColumn = Workbooks("Bond Calculator.xlsm").Sheets("Bond Table").Cells(1, 1).EntireRow
BondColumn.Select ' tester
Exit Sub ' tester
The code works as how I would want it and it highlights the entire first row. What am I doing wrong here? What did i do wrong with the .EntireColumn function?