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

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

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