after testing this, it seems that if you name an entire column, ie G:G
you can select the column by "Name," and you can even select it b
"Name:Name" but "Name" & "21" to get cell G21 won't work, because yo
are essentially asking for the entire column G and tacking a 21 on th
end.

However you could name cell "G1" and then offset by the number of row
you'd like...

Range("TripDate").Offset(iNextRow-1, 0) = TBDate.Value

however, there are wiser heads than mine out here, perhaps someone els
can make it work with the named column... i'd be interested to see tha
work..

--
Message posted from http://www.ExcelForum.com