View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SS[_2_] SS[_2_] is offline
external usenet poster
 
Posts: 12
Default how to refresh entire sheet?

I've got data that displays a value cells by calling that cell

so my cell, for example a1, has =b6

in b6 i have a number.

If i do F2 on the cell the cell updates and shows that number
how can I refresh all the other cells, in one go, in the series so that they
show the numbers that correspond to them?

SS