Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Application.Caller function
Hello,
I am able to implement the following code successfully: Dim RangeVariable As Range Set RangeVariable = Application.Caller Do While RangeVariable.Offset(0, 1).Value < "" Note that the Do While condition tests for < "". I am now trying to make a modification to assign a value, e.g.: RangeVariable.Offset(0, 1).Value = "SomeText" The code compiles but crashes without a hint. Any ideas? Does the problem relate to a function being "gettable" but not "settable", or maybe that's the wrong track? Thanks. Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Application.Caller function
You can't change cells with a function, only return a value to the "caller".
-- Gary''s Student - gsnu200840 "Keith Howard" wrote: Hello, I am able to implement the following code successfully: Dim RangeVariable As Range Set RangeVariable = Application.Caller Do While RangeVariable.Offset(0, 1).Value < "" Note that the Do While condition tests for < "". I am now trying to make a modification to assign a value, e.g.: RangeVariable.Offset(0, 1).Value = "SomeText" The code compiles but crashes without a hint. Any ideas? Does the problem relate to a function being "gettable" but not "settable", or maybe that's the wrong track? Thanks. Keith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Application.Caller function
A function called directly or indirectly from a worksheet cell can only return a value to the whence it was called. It cannot change any part of the Excel environment, including the values of other cells. This restriction is necessary to allow Excel to properly calculate cells in the correct order. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) n Wed, 18 Mar 2009 11:51:13 -0700, Keith Howard wrote: Hello, I am able to implement the following code successfully: Dim RangeVariable As Range Set RangeVariable = Application.Caller Do While RangeVariable.Offset(0, 1).Value < "" Note that the Do While condition tests for < "". I am now trying to make a modification to assign a value, e.g.: RangeVariable.Offset(0, 1).Value = "SomeText" The code compiles but crashes without a hint. Any ideas? Does the problem relate to a function being "gettable" but not "settable", or maybe that's the wrong track? Thanks. Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
application caller | Excel Programming | |||
Row = Application.Caller.Row | Excel Worksheet Functions | |||
Application.Caller | Excel Programming | |||
application.caller | Excel Programming | |||
DDE and application.caller help | Excel Programming |