Thanks for that. Please see my reply to Dave as that may give you a bit
more insight to my problem.

Rob

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Ok, I'll try setting things up a little differently in 2007 and see what
happens. Can't do it right now - business meeting to attend that will run
late, but I'll give it a shot later this evening. I'll presume that since
it
works when rows are not hidden that there's not a problem with the
definition
of Sheet4, and just focus on the copying of values - and whether or not
they
work on my 2007 system.

"RobN" wrote:

Dave,

I'm using the dreaded 2007 version, which is giving me grief in other
areas
as well...GRRRrrrr!! I'm certainly not recommending anyone use this
version
at all.

Rob

"Dave Peterson" wrote in message
...
I couldn't duplicate the problem in xl2003.

What version of excel are you using? Maybe someone with that version
could try
to duplicate it.

RobN wrote:

I have the following code as part of other code which is executed via
a
UserForm.
With Sheet4
.Range("V13:V20").Value = .Range("R5:R12").Value
End With

When I unhide those rows the code works fine.

Part of the range, namely rows 16 to 23 are hidden. When I execute
this
code, those cells located within the hidden range do not reflect the
values
from the R5:R12 range. No error message appears, yet only values are
copied
into the unhidden cells.
Other parts of the code within this procedure do copy the value to the
cells
in the hidden range, eg....
If Range("U9") = True Then Range("V17") = CloseBal

Can anyone see a problem here?

Rob

--

Dave Peterson