my name is EARL
New member
I am writing a VBA macro in an Excel 2003 document. For some reason, when I apply formatting to a range of cells, it generates a run-time error, but it works if I apply it to a singel cell, For example:
ActiveSheet.Cells(4, 2).Font.Bold = True 'This works
ActiveSheet.Range(Cells(4 , 2), Cells(4 , 3)).Font.Bold 'This does NOT work
The error is 1004: Application-defined or object-defined error. It highlights the above line in yellow when I debug it. Any ideas why this doesn't work for a range of cells?
ActiveSheet.Cells(4, 2).Font.Bold = True 'This works
ActiveSheet.Range(Cells(4 , 2), Cells(4 , 3)).Font.Bold 'This does NOT work
The error is 1004: Application-defined or object-defined error. It highlights the above line in yellow when I debug it. Any ideas why this doesn't work for a range of cells?