Hi Everybody,

Using Excel 97, I have a Range object that is Set to a Named Range on a
WorkSheet
e.g.

Dim Rng as Range

Set Rng = ThisWorkbook.Worksheets("MySheet").Range("Incident s")

"Incidents" is a named range that represents the first 10 rows of my
Worksheet and includes only Columns "A","B" and "D" of those 10 rows
(Columns C is excluded)
My problem is when I dynamically populate Rng with values the data ends up
in Columns "A", "B" and "C" (Column D should have contained data instead
Column C holds it)

Rng(j, i).Value = "SomeData"

Where j and i iteratively represent 10 Rows across 3 Columns (Columns "A",
"B" and "D")

Am I allowed to define a Range that skips a column?

Thanks for any help!
Sam