Find a column heading then sorting the sheet off that column

**Cluv** · 04-01-2011, 06:11 PM

hi, my goal for this macro is to find the column heading "invoice number" then sorting the entire or most of the spreadsheet from said invoice number column. i've tried recording it but sometimes the report will have a different amount of columns and rows, so I'm trying to use a do while/if statement to find the column heading first before it sorts. however when I run it doesn't do anything.

Please Login or Register  to view this content.

EDIT: I th ink I'm not implementing the option compare text correctly as well.

**protonLeah** · 04-01-2011, 06:35 PM

Please Login or Register  to view this content.

**tigeravatar** · 04-01-2011, 06:44 PM

Mine's kinda long-winded, but I tested and know it works, so feel free to give it a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**Cluv** · 04-04-2011, 11:07 AM

Originally Posted by protonLeah

Please Login or Register  to view this content.

I tried this and the error message says object doesn't support property or method. Let me try showing you the entire code.

Please Login or Register  to view this content.

**protonLeah** · 04-05-2011, 12:16 AM

The line

Please Login or Register  to view this content.

was meant to replace the loop

Please Login or Register  to view this content.

When run it would return the range data for the column where it found the header.

Then found.address(0,0) would give the address if the cell, say G1, or something, that would be used in the sort.