I have a very large spreadsheet with array formulas (aka CSE formulas) in every cell. For me to activate the formulas I need to place my cursor in the formula bar and hit Ctrl+Shift+Enter for *every cell*, which in my case is about 9,000 cells.
Is there any way to activate the CSE formulas for all cells at once?
Any help is greatly appreciated.
Thanks,
Franco
Hi,
This code will convert all formaulas within selection to arrays.
Sub frm2array() Dim frm As Variant, rcell As Range For Each rcell In Selection frm = rcell.Formula rcell.FormulaArray = frm Next rcell End Sub
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Perfect. That did it. You just saved my mucho hours of monkey work!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ffinstad 
Register To Reply
Bookmarks