Thread: adjust range size??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ricksimm[_3_] ricksimm[_3_] is offline
external usenet poster
  
Posts: 1
Default adjust range size??

I am using a data validation list defined as a range using =PartsList.
If the range was initially set up as A1:A10 and I change the rang
(delete the data in A4), is there some way in VBA that I can adjust th
size of the range to now be A1:A9 so that I can continue to use th
=PartsList for validation? Thanks

--
ricksim
-----------------------------------------------------------------------
ricksimm's Profile: http://www.excelforum.com/member.php...fo&userid=2189
View this thread: http://www.excelforum.com/showthread.php?threadid=38239

Reply With QuoteReply With Quote