Hi, Im pretty new to this but have been successful getting Range(“A1” & .Row).Value to copy and accumulate to say cell B1. Based on a Target,Range value, using a Worksheet Change event.
However, I cant seem to get Column to work in the same logical way.
Im trying to get any value that shows up in say Column A1:A10 to Reproduce in the adjacent cell of the value shown, and accumulate.
So I tried something like
Range(“B” & .Column).Value = Range(“A” & .Column).Value + Range(“B” & .Column).Value and it didnt really work.
I say really because it did sort of work. It placed a value in an adjacent cell in column B but not next the cell thar got its value in Column A. In fact it for some reason chose row 6.
I have a list of values that is 37800 lines so mapping the values returned, to each adjacent cell in the column, I dont think would work either. It would probably stack out. Any help would be great.
__________________________________________________________________
However, I cant seem to get Column to work in the same logical way.
Im trying to get any value that shows up in say Column A1:A10 to Reproduce in the adjacent cell of the value shown, and accumulate.
So I tried something like
Range(“B” & .Column).Value = Range(“A” & .Column).Value + Range(“B” & .Column).Value and it didnt really work.
I say really because it did sort of work. It placed a value in an adjacent cell in column B but not next the cell thar got its value in Column A. In fact it for some reason chose row 6.
I have a list of values that is 37800 lines so mapping the values returned, to each adjacent cell in the column, I dont think would work either. It would probably stack out. Any help would be great.
__________________________________________________________________
Mod edit : post moved to appropriate forum …