"Gary''s Student" wrote:

use
Range("F6:G22", "K6:K17").ClearContents
instead of
Range("F6:G22", "K6:K17").Clear
that works great accept it is clearing everything in between H-J column.
just want what i specified in F, G, and K cloumn i just want the specified
cells to clear