Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to a specific column in whatever row the cursor is currently
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cursor to specific cell from a specific cell | Excel Discussion (Misc queries) | |||
need to move cursor to specific fields | Excel Worksheet Functions | |||
automatically move cursor to top of a column | Excel Discussion (Misc queries) | |||
how to move the cursor to column A after entering data column F | New Users to Excel | |||
move cursor to 4th column with one press of tab key? | New Users to Excel |