How do I sort all my rows which I have A-Z based on ascending A-Z on column M I have tried the following but it hasn't worked any idea what I might be doing wrong?
Range("A1", Range("Z" & Rows.Count).End(xlUp)).Sort [M1], xlAscending
How do I sort all my rows which I have A-Z based on ascending A-Z on column M I have tried the following but it hasn't worked any idea what I might be doing wrong?
Range("A1", Range("Z" & Rows.Count).End(xlUp)).Sort [M1], xlAscending