Reduce size of Range - Syntax question

[parsellj]

I hope this is a trivial question!
Given a Worksheet variable - WS,
and a Single Column Range on that Worksheet - V (eg G1:G260),
and an Index -- i where i is the index of the first row of interest in that range (eg 12),
What is the VB or VBA syntax for setting V to be the Range starting with G12 and ending at G260.

I am looking for the "proper" idomatic way to do this and am having a mental block.
TIA,
Jim

 

[pgc01]

Hi Jim
Welcome to the board

Try:

Sub Test()
Dim ws As Worksheet
Dim r As Range
Dim i As Long

Set ws = Worksheets("Sheet3")
Set r = ws.Range("G1:G260")
i = 12

' syntax for setting V to be the Range starting with G12 and ending at G260.
Set r = ws.Range(r(i), r(r.Rows.Count))

MsgBox r.Address(external:=True)
End Sub

 

[Rick Rothstein]

This thread appears to be a duplicate of this one (which has already received some responses)...

http://www.mrexcel.com/forum/excel-questions/679196-reduce-size-range-syntax-question.html