View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
mailrail mailrail is offline
external usenet poster
 
Posts: 28
Default Check box cell link - copy problem

Yeah...I sort of figured that. Anyone have one already written?

"Jim Rech" wrote:

You'd need a macro.

--
Jim
"mailrail" wrote in message
...
| I'm developing a spreadsheet that's going to have over 100 checkboxes that
| each have a specific cell link. After I created one row, I attempted to
copy
| them all to the next row down but the cell link of the check box still
| referenced the original cell in the prior row. Is there an easy way to get
| the cell link to change to the new cell when copying or do I have to
change
| each of these individually (OUCH!)?