View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Looping through a range of cells


"Jamie Collins" skrev i melding
om...
A textbox is not next to any cell, it floats above the spreadsheet on

the so
called "drawing layer". So it has no idea what's "next to" because it's
below and it's independent.


I'm not sure it's as simple


You're absolutely right Jamie, my reply is oversimplified. But the layer
stuff is real, and the cell relations you mention is somewhere between
impossible to handle and impossible to get to. If I had a reasonable way to
do this, I'd be glad and proud to provide it. Likewise if someone proves me
wrong -those solutions are always fantastic and worth the pain of posting
"impossible" when it's not :-)

Best wishes Harald