Thread: ACTIVATE CELLS
View Single Post
  #1   Report Post  
mdeanda
 
Posts: n/a
Default ACTIVATE CELLS

I have large matrix with forumlas that i want to copy into 65 different excel
files.
The formulas pick up new data in the destination file and return new results.

However, I need to use the F2 key and ENTER on each cell before the formulas
recalculate. I have a 25X20 matrix and this process takes a long time.

Is there a way to automatically activate the entire spreadsheet or range of
cells?