I want to select from rows A to I, until the text "total" shows up in Column A. Is there any way this could be done in VBA