I have attempted to use the macro recorder to do this, however, it just does not do what I want...
I want to create a macro that can be done via my keyboard (let's say ctrl + z) that will do the same as when I double click the corner box.
HOWEVER, the macro will only fill to the same number of cells as when I did it with the recorder rather than automatically going to the length of cells on the right.
Can anybody help me on this one?
I want to create a macro that can be done via my keyboard (let's say ctrl + z) that will do the same as when I double click the corner box.
HOWEVER, the macro will only fill to the same number of cells as when I did it with the recorder rather than automatically going to the length of cells on the right.
Can anybody help me on this one?