Following is a very simple macro. All i need to know is how to re-write that so that when it has run, i can then apply it to the line that has been moved to (i.e. 417), or whatever line i want (not just 416).
Range("B416:J416").Select
Selection.Font.bold = True
Range("B417").Select
It has been suggested that a for loop would work, but i have no way of finding out how to do that.
Thanks for your help if you can do it. If not, don't worry - i'm sure someone can...
Range("B416:J416").Select
Selection.Font.bold = True
Range("B417").Select
It has been suggested that a for loop would work, but i have no way of finding out how to do that.
Thanks for your help if you can do it. If not, don't worry - i'm sure someone can...