I have an excel, that is used to record daily flow of business. In the A column is the date of registration and in the other columns information about the item.
I need to put borders below the row of each last date, to visualize the individual dates better. This should looks something like this.
How the excel should look
I am fairly new to VBA and found out how to put borders around the cell, but I am unsure on how to get VBA to run through every date and only select the last one of each batch.
I tried conditional formatting, but it did not quite do the job. With VBA I was able to put borders around speficic cells with :
Range(“A1”).Borders(xlEdgeBottom).LineStyle = xlContinuous
But I am unable to find out how to reference the specific rows of the sheet.
noah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.