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?
Bookmarks