View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Copy contents of Range to other cell

So solly, Didn't read that part.

"GB" wrote in message
...

"Don Guillett" wrote in message
...
try
[bill!a1].copy [bill!a28]
or for just the value
[bill!a28]=[bill!a1]

Beg your pardon Don, but doesn't that just copy cell A1 to A28. What the

OP
wanted was to look in Cell A1, read it's contents and use that as the

range
to copy from, then copy *that* range to A28. At least that was what I
thought he wanted.

GB