Updating a named range with SQL like command
 

Hello,
I'm trying to update specific rows in named range based on criterea in
several cells. I know this would be very easy in Access but
unfortunately I need to keep all the data in EXCEL as well as the
interface. So basically I would like to write an SQL update query
against a named range. Is this possible? Do I have to use ADO to do it?