Move to a specific column in whatever row the cursor is currently
Columns B thru U:
Private Sub Worksheet_Change(ByVal Target As Range)
Set t = Target
Set r1 = Range("B:U")
If Intersect(t, r1) Is Nothing Then Exit Sub
Cells(t.Row, "V").Select
End Sub
Goes in the worksheet code area, not a standard module.
--
Gary''s Student - gsnu200774
"PeteRooney" wrote:
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
|