Thank you for trying to explain a solution. The concept is very straight
forward I just wanted the value input in next available row between 6-199
and a formula refrencing that cell in the matching column between 202-231.
I have a freelancer working on this project now so all is good.
On Monday
It's VERY confusing trying to follow what you're doing...
it seems like you're using chr() functions to convert characters to STRINGS?
which doesn't make ANY sense.
I'd like to first address your solution, then ask what it is you're trying to
do? (lol)
For your code:
ActiveSheet.Cells(i, 2).Val
