jmenche
10-11-2005, 09:12 AM
Hi,
I have a spreadsheet that has 4 worksheets with similar ranges. Each range has 4 columns with the first one being descriptive and the other 3 having a rank. I wanted to add in sorting functionality based on the 3 columns with ranks. I did this by adding a transparent rectangle to each column heading and attaching a macro that sorts the range by that column ascending.
I realized that there are 12 subroutines now that are very similar. Is there a way to do this better using relative references to an activecell?
Thanks
I have a spreadsheet that has 4 worksheets with similar ranges. Each range has 4 columns with the first one being descriptive and the other 3 having a rank. I wanted to add in sorting functionality based on the 3 columns with ranks. I did this by adding a transparent rectangle to each column heading and attaching a macro that sorts the range by that column ascending.
I realized that there are 12 subroutines now that are very similar. Is there a way to do this better using relative references to an activecell?
Thanks