Thread: Selecting and deleting named range based on cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Kniatt[_5_] Rich Kniatt[_5_] is offline
external usenet poster
  
Posts: 1
Default Selecting and deleting named range based on cell value

I'm using a count function to return a value to cell M5.

I am trying to figure out the VB code to use that value to delete a
named range based on the following:

If M5 <20 delete range4
If M5 20 but <41 delete range3
If M5 20 but <61 delete range2
If M5 20 but <81 delete range1


--
Rich Kniatt
------------------------------------------------------------------------
Rich Kniatt's Profile: http://www.excelforum.com/member.php...o&userid=19093
View this thread: http://www.excelforum.com/showthread...hreadid=530641

Reply With QuoteReply With Quote