R
Rob
I am trying to make a workbook that sorts my slection then sends the info to
its repective worksheet via VLookup. I'm having a problem with my macro for
sorting. The problem is that there needs to be rows which are merged cells
contaning info that doesn't need to sorted but the macro copies these rows
with the rest to a remote part of the "Master" worksheet then sorts the info.
When it gets to the sprting portion I get an error stating "Run-time error
'1004': This oporation requires the merged cells to be identically sized" I
was wondering if there is a way to edit the macro in VBA to skip those rows
during the sort or omit them from the copy prior to sorting.
its repective worksheet via VLookup. I'm having a problem with my macro for
sorting. The problem is that there needs to be rows which are merged cells
contaning info that doesn't need to sorted but the macro copies these rows
with the rest to a remote part of the "Master" worksheet then sorts the info.
When it gets to the sprting portion I get an error stating "Run-time error
'1004': This oporation requires the merged cells to be identically sized" I
was wondering if there is a way to edit the macro in VBA to skip those rows
during the sort or omit them from the copy prior to sorting.