Thread: Set variable sort range based on found text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeffbert jeffbert is offline
external usenet poster
  
Posts: 50
Default Set variable sort range based on found text

I need to sort a worksheet from columns A10:AE, with the last row of the
sort procedure being two rows above where "XYZ" is found in column A. There
are blank cells in the range also.

For example:

XYZ is in cell A110. I need to sort the using the range A10:AE108

Any and all help is greatly appreciated.
Reply With QuoteReply With Quote