Your now trying to assign the value found at rng4.Offset(0, 20) to the
range pointed to by rng6, but you haven't set rng6 yet. Did you mean

Set rng6 = rng4.Offset(0, 20)

?

In article ,
justagrunt wrote:

And now error at
rng6 = rng4.Offset(0, 20) ' 0 cells down 20 cells across is the offset
which has the same error even with "Set rng6......." of
"Object variable or with block variable not set"

What could be causing this now?