View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karenna Karenna is offline
external usenet poster
 
Posts: 1
Default How to activate array formulas in a range of cells all at the same time?

The formulas have already been entered, and they are different in eac
cell. Is there a macro that can activate a range of cells when
highlight all of them? If I do that now, it copies one formula to th
rest of the cells. Please let me know if there is any way to do this?

Basically, I'd just like a way around going to each cell and typing F
Cntl-Shift-enter.

Thanks,
Karenn

--
Message posted from http://www.ExcelForum.com