VBA Range syntax help

[michaeltsmith93]

I'm wondering if someone can point me in the direction of a resource that describes the syntax of different combinations of ranges like below. I have trouble remembering the right syntax for concatenating the different items, and I'd just like to bookmark a page that has examples of these types of things for quick reference. Even just telling me what search terms to use on Google would be helpful. My searches aren't yielding what I want.

Dim NamedCol As Long

NamedCol = WorksheetFunction.Match(blah blah blah)

Range(NamedCol & "5:" & NamedCol & "500") blah blah blah

'OR

Dim NamedRng As Range

NamedRng = WorksheetFunction.Index (blah, WF.Match, WF.Match)

Range(NamedRng & ":F5")

 

[Fluff]

Have a look here http://excelmatters.com/referring-to-ranges-in-vba/

 

[michaeltsmith93]

Thank you, Fluff--this is perfect.

 

[Fluff]

You're welcome & thanks for the feedback