Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"Walter Briscoe" je napisao u poruci
interesnoj ... This is an excerpt from some working code: With Workbooks("stations.xls").Sheets("Sheet1") Here = ActiveWorkbook.Name: .Activate ' See what is going on When I comment the "Here = ..." line, the "s = Evaluate..." does not work as intended. after 'name' there is a colon ':', is it intentional? colon ':' is a command separattor, so on that line you have actualy two commands, '.activate' being the second it is a bad practice, since program flow is not so clear |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
evaluate | Excel Worksheet Functions | |||
Why Evaluate? | Excel Programming | |||
Problem with Evaluate | Excel Programming | |||
HOW to Evaluate a range with IF ? | Excel Discussion (Misc queries) | |||
Evaluate or WorksheetFunction Problem | Excel Programming |