View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jchick0909 jchick0909 is offline
external usenet poster
 
Posts: 11
Default absolute reference fill

i have 235 lines each linking to a cell in another tab. I need to make each
cell an absolute reference so i can copy them down again below and the same
cell is referenced.

How to I insert Absolute Reference in multiple cells. (i've tried macro's
but i failed).

Thanks in Advance