Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How run Evaluate on a specified Sheet
Hi all,
I am trying to run Evaluate on a sheet that is not currently active. I have a formula stored as a String. The Evaluate function works great on the currently active sheet. But when I try to attempt the same Evaluate function on another sheet, it fails.. Dim fStr As String Dim listing As Variant Dim rng As Range Dim codeSheet As String listing = Evaluate(ThisWorkbook.Sheets(codeSheet)!fStr) Here fStr is the expression to evaluate. This is not working. If I remove the ThisWorkbook.Sheets(codeSheet)!, it will just work fine, but always works only on the active sheet. Please advise me how I can correct this. Thanks in advance, shishi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
evaluate | Excel Worksheet Functions | |||
evaluate cell value with sheet name | Excel Worksheet Functions | |||
Problem with Evaluate | Excel Programming | |||
Evaluate formula using VBA | Excel Discussion (Misc queries) | |||
Evaluate error when using 2 | Excel Programming |