GTretick
Member
I'm looking to bold a dynamic range by using variables to set the range
To start with I can't get the syntax right so that VBA understands what I want.
The following line would bold from A1 to D4 (except it doesn't). I would swap out the various digits with variables so the range can change based upon various conditions.
I'm starting with hard coding the coordinates to break the problem down into an easier bite sized piece.
From what I can tell from Google, this should work but it doesn't do anything to my active sheet.
What do I need to change in the line to make it work?
Range(Cells(1, 1), Cells(4, 4)).Font.Bold = True
Thanks.
To start with I can't get the syntax right so that VBA understands what I want.
The following line would bold from A1 to D4 (except it doesn't). I would swap out the various digits with variables so the range can change based upon various conditions.
I'm starting with hard coding the coordinates to break the problem down into an easier bite sized piece.
From what I can tell from Google, this should work but it doesn't do anything to my active sheet.
What do I need to change in the line to make it work?
Range(Cells(1, 1), Cells(4, 4)).Font.Bold = True
Thanks.