From: MikeF on 31 May 2010 14:45
Would like to take a range and resize it by 2 columns less on the right and
one column less on the bottom.
Any assistance will be greatly appreciated.
From: Gary''s Student on 31 May 2010 14:52
Selection.Resize(Selection.Rows.Count - 1, Selection.Columns.Count - 2).Select
Gary''s Student - gsnu201003
From: Per Jessen on 31 May 2010 15:00
It is not much information you give us to work with.
In my example, the selected range, will be reduced by 1 row and by two
Dim rng As Range
Set rng = Selection
Set rng = rng.Resize(rng.Rows.Count - 1, rng.Columns.Count - 2)
On 31 Maj, 20:45, MikeF <Mi...(a)discussions.microsoft.com> wrote:
> Would like to take a range and resize it by 2 columns less on the right and
> one column less on the bottom.
> Any assistance will be greatly appreciated.
From: Wouter HM on 31 May 2010 15:04
In Excel 2003 I have created this:
Dim rngMine As Range
Dim lngRow As Long
Dim lngCol As Long
If Selection.Rows.Count > 1 And _
Selection.Columns.Count > 2 Then
lngRow = Selection.Rows.Count - 1
lngCol = Selection.Columns.Count - 2
Set rngMine = Range(Selection.Cells(1, 1), _