I have the following code and need to mark a specific cell in an excel sheet bold:
.Visible = True
.worksheets(1).Cells(2, 1).Value = "TEST"
.worksheets(1).Cells(2, 1).HorizontalAlignment = xlCenter
unfortunately this generates an error and I have tried many different versions with no success. Thank you for any help!