Thanks for looking at this one.....

when writing a macro in visual basic, how would you write code to do
something like this:

IF "Named Range 1" is not equal to "Named Range 2" THEN (do a simple
cut/copy/paste which I've allready figured out) ELSE END IF

I can do this with range as cell address ("A2") but don,t know how to
reference the Named Range.

Thanks....

Spydor


--
spydor
------------------------------------------------------------------------
spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438
View this thread: http://www.excelforum.com/showthread...hreadid=498554