Key1: Range Problem in Data Sort

[Ron Greer]

First time Forum user. The Macro below works but I need for the Key1 Range to be the active cell at column "CD" instead of "CD57". In other words, I am doing all of the sorting on a single row but the row number will vary depending on the row number of the active cell.

Thanks for your help.

Ron

Please Login or Register  to view this content.

[JosephP]

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

note code tags are required by the forum rules when posting code

[Ron Greer]

JosephP

That was what I was looking for. Been searching for hours. Thanks for your help.

Ron