(Solved) : Create Vba Subroutine Takes Selected Column Vector Cells Replaces Values Repeated Sequence Q36596984 . . .
Create a VBA subroutine that takes a selected column (vector) ofcells and replaces those values with
repeated sequences of 1-2-3 going down the column. If the number ofrows in the column are not divisible
by 3, the last row will terminate with a 1 or 2. You may want touse the mod function in VBA.
1-23-12 3-123 12-3 – 10 11 12 13 14 16 17 18 123456789 0 1 2 3 4 5 6 7 89 01234567 Show transcribed image text
Expert Answer
Answer to Create Vba Subroutine Takes Selected Column Vector Cells Replaces Values Repeated Sequence Q36596984 . . .
OR