Thread: Code to change a named range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
joel[_890_] joel[_890_] is offline
external usenet poster
  
Posts: 1
Default Code to change a named range

Why don't you simply add back the named range in the macro after you
delete the rows


ActiveWorkbook.Names.Add Name:=BOAssociate, RefersToR1C1:="=OFFSET('BO
Ref List'!$B$2,0,0,COUNTA('BO RefList'!$B$2:$B$989),1)"
ActiveWorkbook.Names.Add Name:=FOAssociate RefersToR1C1:="=OFFSET('FO
Ref List'!$B$2,0,0,COUNTA('FO RefList'!$B$2:$B$985),1)"


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=195192

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote