Hi,
while recording a macro i've selected multiple sections of data and then
divided a value to all of the data selected by copying the cell with the
value in it and selecting paste special, checking off divide, and values. It
seems to work on all sections when i'm recording the macro, however, when i
run the macro on another sheet it only seems to work on the first section of
data i selected. would anyone know why this is?
Many thanks in advance