Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluating formulas when a template is brought into a worksheet...
ahh, I see I didn't even need the integer i .
I started to do something slightyly different, and then missed taking that back out. "mark" wrote: Hi. I have a template that has a bunch of formulas in it. It is stored as a template, and then programatically brought into a workbook. Some of the formulas in the template are intended to perform lookups against named ranges in the worksheet that it is brought into. However, the formulas do not evaluate when the template is brought in. At first, I thought that just forcing a recalc would take care of it, but it does not. If I put this sbEval in, the formulas evaluate, and everything's fine: *********** Sub sbEval() Dim c As Range Dim i As Integer i = 1 For Each c In Range("rgRateLookup").Cells c.Formula = c.Formula Next c End sub ************* Is there a different better way to do that? It's not a lot of cells, this will work. It's just that I thought recalc would handle it, and it didn't. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identifying cells brought in from another worksheet | Excel Discussion (Misc queries) | |||
Inventory Brought Foward | Excel Worksheet Functions | |||
kill formatting brought over from reports | Excel Discussion (Misc queries) | |||
Evaluating Today() function only once in a worksheet | Excel Worksheet Functions | |||
Moving in the worksheet during an evaluating function | Excel Programming |