Hello,
I have a range of cells that I need to use in another function. The range is in a variable called "selection" and the cells in it can be any number of rows, but are guaranteed to be in one column. What I need is to take the cells in this range, and take all of the cells that are a few columns over from the range and change their values. So if the cells in the range are A1, A2, and A3, I need to change the values of B1, B2, and B3 to "Y", for example. Any hepl would be greatly appreciated.
I have a range of cells that I need to use in another function. The range is in a variable called "selection" and the cells in it can be any number of rows, but are guaranteed to be in one column. What I need is to take the cells in this range, and take all of the cells that are a few columns over from the range and change their values. So if the cells in the range are A1, A2, and A3, I need to change the values of B1, B2, and B3 to "Y", for example. Any hepl would be greatly appreciated.
