View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Cell references and merged cells

"Howard Kaikow" wrote in message news:%23

Due to the merge, I have to use Cells to refer to any of the cells A1:A5.
But, I can refeer to the cells B2:B5 using an Offset from the

corresponding
A2:A5.


That'll be because you are only merging cells in a single row, I assume.

In your earlier adjacent post
Got up a few hours later to do errands, including stopping at
bank to deposit a whopping $5 check.


I still have a cheque from Bell for the princely sum of ten cents $0.10
mailed to me from US to UK. A public phone had chewed up my last dime. I was
annoyed, without it even the operator could not connect me. Though she very
politely offered to refund. I couldn't believe it when the cheque arrived up
a long time later.

Regards,
Peter T