I could be totally off whack here so please shout at me if I
am... it sounds as though you want to be totally certain the value goes
where you want it.

Do you have any unique column headers? It may be possible to scan along the
headers to look for a column to put  your data in. That's assuming noone is
going to change the header text... :-)

I've had a lot of success with scanning down rows and across columns and
setting a certain cell  to a range so I can enter  stuff there.

I's a bit "simplistic" I know but it only fails on the odd case where people
insist on changing those headers!!