Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing cell address to sub - write that cell
What am I doing wrong?
function xx (x as range) as whatever x.value2 = "test" or x.text = "test" compiles - I can see the object - but bombs. ???? Entered function in cell as xx(B5) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing cell address to sub - write that cell
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing cell address to sub - write that cell
wrote:
What am I doing wrong? function xx (x as range) as whatever x.value2 = "test" or x.text = "test" [....] Entered function in cell as xx(B5) When VBA code is invoked directly or indirectly from a formula in an Excel, the VBA code cannot modify cells directly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing single-cell vs multi-cell ranges to a variant array? | Excel Programming | |||
how do I write a formula: if (cell address) is less than X add Y | Excel Discussion (Misc queries) | |||
Passing Cell Address (String or Range) | Excel Programming | |||
Passing Cell Address to Offset | Excel Worksheet Functions | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |