I am very new to VBA. I believe there is an easy way to get this info, but I just have not found a way.
I want to select a portion of a worksheet (~30 rows by 13 columns; the rows are different each time, the columns are constant), and I want to Sort the rows on column B.
I have recorded a macro that works, but I cannot get it to Sort a different selected range. I have tried various versions of ActiveRange and Selection, but have not found the answer.
Thank you for your interest and your assistance.
I want to select a portion of a worksheet (~30 rows by 13 columns; the rows are different each time, the columns are constant), and I want to Sort the rows on column B.
I have recorded a macro that works, but I cannot get it to Sort a different selected range. I have tried various versions of ActiveRange and Selection, but have not found the answer.
Thank you for your interest and your assistance.