View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jeffreybarlow@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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?