Hi All,

One more problem...

I am defining the range name in the column F after counting the number
of data items in Column F starting from F2 (stored in Count1). I am
using this code:


Range("F2").Select
Cells(2, "F").Resize(Count1, 1).Select
ActiveWorkbook.Names.Add Name:="InitType", RefersToR1C1:="=List!
R2C6:R11C6"

However, looks like the refers to column is static and always naming
F2:F11 range no matter what the count is...IS there any way I can
include Count1 Variable in the "Refers to" part as well

Thanks in advance,
Anshuman