Good evening, all,

I'm writing a worksheet_change macr that will set a value in column V of the
target row if a change is made in any of the columns B to U.
So, if I make a change in any cell from A15 to U15, I want to select/goto
V15, and so on.
I have stored column V's column number to a variable ("AmendDate"), so that
if I insert/delete any columns, the code will work out where column V has
moved to.
I wrote a piece of code many moons ago that went something like:
Range("R" & target.row & "C" & AmendDate).select
but it doesn't work quite as I want it to... well, it doesn't work at all!
Can anyone suggest a line of code that will work with either the letter
reference of the column (in this case "V"), or ideally, using the column
number variable stored in "AmendDate"?

Thanks in advance for your help. :-)

Pete