How to define a variable as a range

[mtheriault2000]

Hello

How can i define a variable:Listing as a range value

My actual code

dim Listing as range
listing = Sheets("Formulaire").Range("OrderListing").Address

listing.Offset(ct, C) = TwsLink.GET_ORDER_VAL(v, 1)

The actual code is not functioning

Martin

 

[mikerickson]

When assigning a value to an object variable the keyword Set has to be used.
Objects are things like Worksheets,CheckBoxes, and Ranges.

So the syntax for having the variable Listing refer to the named range OrderListing would be

Dim Listing As Range

Set Listing = Sheets("Formulaire").Range("OrderListing")

This assumes that there is a named range OrderListing in the workbook that does refer to some cells on the sheet Formulaire.

 

[mtheriault2000]

Set was the missing link

Martin