I have a spreadsheet page made of 14 columns and on average 60 rows - some are standard height & others larger and is planned to be sorted on a time of hours & minutes based on one column.
Currently I cut and paste the rows because i had merged cells. After reformatting the cells, I now have a macro that sorts the data OK but the row formatting of height is ruined.
Is it possible to sort data ( meaning the rows) and maintain the row formatting ? if so, what do I do to change my macro
Ron
PS sorry for spelling errors in Subject - unable to edit it.
Currently I cut and paste the rows because i had merged cells. After reformatting the cells, I now have a macro that sorts the data OK but the row formatting of height is ruined.
Is it possible to sort data ( meaning the rows) and maintain the row formatting ? if so, what do I do to change my macro
Code:
With Worksheets("Tawnton")
.Sort.SortFields.Clear
.Sort.SortFields.Add Key:=Range("Tawnton_time"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With .Sort
.SetRange Range("Tawnton_data")
.Header = xlGuess
.Orientation = xlTopToBottom
.Apply
Ron
PS sorry for spelling errors in Subject - unable to edit it.
Last edited: