Assuming you already know how to insert values into a sql server table,
you would simply have to refer to the value property of the range name.

In this example, test is a global range name; department is a field within a
sql server table.

..Fields("department") = Range("test").Value