| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a ' } ' into excel so that I can adjust its size? | Excel Discussion (Misc queries) | |||
| adjust automatically size margins | Excel Discussion (Misc queries) | |||
| How do I adjust the font size in a Combo Box? | Excel Discussion (Misc queries) | |||
| Adjust the size of cells automatically | Excel Discussion (Misc queries) | |||
| How would I adjust size for printing | Excel Discussion (Misc queries) | |||
![ricksimm[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
