| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RESIZE PROPERTY: is it possible to resize "up" and "to the left"?
Suppose I have Range D10 as pivot. Is it possible to resize to E5:H10 The logical *Range("D10").Resize(-3,-5)* fails. Can the rowsize columnsize arguments be made to take on negative values? Myles -- Myle ----------------------------------------------------------------------- Myles's Profile: http://www.excelforum.com/member.php...fo&userid=2874 View this thread: http://www.excelforum.com/showthread.php?threadid=52510 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RESIZE PROPERTY: is it possible to resize "up" and "to the left"?
Hi Myles,
Not possible for the Resize method's argument to take on negative values. But why not try this instead: Range("D10").Offset(-6,1).Resize(4,6) Frederick Chow Hong Kong "Myles" wrote in message ... Suppose I have Range D10 as pivot. Is it possible to resize to E5:H10? The logical *Range("D10").Resize(-3,-5)* fails. Can the rowsize, columnsize arguments be made to take on negative values? Myles. -- Myles ------------------------------------------------------------------------ Myles's Profile: http://www.excelforum.com/member.php...o&userid=28746 View this thread: http://www.excelforum.com/showthread...hreadid=525101 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I resize the "name box" in Excel (just left of the fx bar) | Setting up and Configuration of Excel | |||
| Footer font resize when "fit to page" | Excel Discussion (Misc queries) | |||
| How to resize "check box" in excel 2003? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
![Myles[_57_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
