Im not sure if I understood your problem well , but a simple way to have adynamic range is to use the codeRange(Inputbox("please define the range")) so you can define different rangeeach time