Help with run-time error
on it's way!
" wrote:
OK, happy that the copy happens in the previous line the copy that you
are doing is F15:Fsomething.
My suggestion on B is to do away with the copy and paste
I'm ASSUMING (though I haven't run it) that the rng is returning a
single cell value - but I'm not sure you only want one co-ordinate, as
offset(1) would be one row down, not one column across.
C - again, haven't run the code, but I'm expecting that the line should
read
rng.offset(1).pastespecial :=xlPasteValues
would it help to mail me a file )
|