I have a series of cells in a column and I would like to programatically add an underline each time there is a break in the cell value. For example,
100
100
100
100
200
200
250
400
400
400
400
Any ideas?
I have a series of cells in a column and I would like to programatically add an underline each time there is a break in the cell value. For example,
100
100
100
100
200
200
250
400
400
400
400
Any ideas?
Maybe
Change Column letter to your column
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Sorry, I should have been more clear. I want the cell underlined, not the text in the cell.
Change to
VBA NoobPlease Login or Register to view this content.
One more alteration. How can I change it to underline all cells from Column A-L ?
Try
VBA NoobPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks