LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default Resize query

Try...
myrange.Resize(7).Select
--
Jim Cone
Portland, Oregon USA
custom sorting... http://www.contextures.com/excel-sort-addin.html




"Graham"
wrote in message ...
Very basic but I cannot get this work work and do not understand why.I
would appreciate any help
Graham

Dim myrange As Range
Set myrange = Range("AF1").CurrentRegion

myrange.Resize(7, 0).Select

I keep getting an application defined or object defined error.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Resize Les Excel Programming 2 June 11th 08 06:07 AM
I could NOT resize the axis title but excel allows me to resize gr Iwan Setiyono Ko Charts and Charting in Excel 4 June 6th 06 04:46 AM
RESIZE PROPERTY: is it possible to resize "up" and "to the left"? Myles[_57_] Excel Programming 1 March 22nd 06 04:57 AM
I could NOT resize the axis title but excel allows me to resize gr Iwan Setiyono Ko Charts and Charting in Excel 0 March 15th 06 10:34 AM
Need some help with Resize. Thanks John Wirt[_2_] Excel Programming 2 July 31st 03 08:37 AM


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"