LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas assignment from array to range in VSTO Excel doesn't work vsto excel array to range Excel Worksheet Functions 0 December 11th 07 04:48 PM
Sum Array Range & Individual Cells Native Excel Discussion (Misc queries) 1 December 5th 07 08:10 PM
Array Formula Not Working with Range with Formulas [email protected] Excel Discussion (Misc queries) 4 February 1st 06 02:01 PM
Use Array to activate workbooks Stuart[_5_] Excel Programming 3 December 2nd 03 08:17 PM
Array formulas are not valid in merged cells. [email protected] Excel Programming 1 October 17th 03 04:13 PM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"