Resize query
in [Programming]
|
From: Graham on 9 Apr 2010 17:31 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.
From: Jim Cone on 9 Apr 2010 17:50 Try... myrange.Resize(7).Select -- Jim Cone Portland, Oregon USA custom sorting... http://www.contextures.com/excel-sort-addin.html "Graham" <graham(a)haughs.orangehome.co.uk> wrote in message news:em4cFvC2KHA.5036(a)TK2MSFTNGP02.phx.gbl... 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.
From: Graham on 9 Apr 2010 18:03 Oh dear, a lot of humble pie I think! Many thanks for patience and quick reponse. Graham On 09/04/2010 22:50, Jim Cone wrote: > Try... > myrange.Resize(7).Select
From: FSt1 on 9 Apr 2010 18:24 hi it is not possible to have a range 0 columns wide. change to....... myrange.Resize(7, 1).Select also not possible to have a range 0 rows high. Regards FSt1 "Graham" wrote: > 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. > . >
|
Pages: 1 Prev: How to select combobx value with vba? Next: Deleting veryHidden worksheets |