ActiveWorkbook.Names.Add Name:="rangenamehere", RefersToR1C1:="=SOF!R1C1"

just place that inside an IF....THEN BLock


--
When you lose your mind, you free your life.


"jhahes" wrote:


How do I name a range with an if statement

Say on a worksheet change on sheet4

If I add a record to the database the new record will go into a certain
range.



Here is what i am trying to do

Search thru say Column C

If the search finds a 1 then it would select it or activate it

All the selected fields would be named a range (Range_1)


In my case all records are sorted so all the ones would be consecutive,
but could you do this same scenario with records out of order


I would appreciate any input or help

Thank you for your time

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=378140