Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110455
| From | dpb <none@none.net> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Enter value in compute cell location? |
| Date | 2018-01-22 08:51 -0600 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <p44tpi$5ce$1@gioia.aioe.org> (permalink) |
| References | <p3lu7i$btb$1@gioia.aioe.org> <p43k81$24n5$1@adenine.netfront.net> <p44t36$45o$1@gioia.aioe.org> |
On 1/22/2018 8:39 AM, dpb wrote:
> On 1/16/2018 7:06 PM, Jianguo Li wrote:
...
DANG! Need to fix a couple typos...
> OK, here's the working implementation --
...
> Sub SetValue(RefCell As Range, offSrce As Long, offTarg As Long)
> ' Set cell at OFFSET(REFCELL(0,offTARG) with value from
> ' OFFSET(REFCELL(0,offSRCE)
> ' Uses SUB to do dirty work since UDF can't directly alter itself
Just saw hadn't made intended edit to above comment -- should read as or
equivalent to
' Uses SUB via .Evaluate to do dirty work since UDF can't directly alter
' cell location other than itself
...
> And, just for funs, another function found that allows you to add
> IntelliSense help for UDFs...
>
> Sub DescribeFunction()
> Dim FuncName As String
> Dim FuncDesc As String
> Dim Category As String
> Dim ArgDesc(1 To 3) As String
...
For the specific example, there are four arguments so
Dim ArgDesc(1 To 4) As String
--
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Enter value in compute cell location? dpb <none@none.net> - 2018-01-16 16:26 -0600
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-18 13:56 -0600
Re: Enter value in compute cell location? "Jianguo Li" <2@1.com> - 2018-01-17 09:06 +0800
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-22 08:39 -0600
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-22 08:51 -0600
Re: Enter value in compute cell location? killme2008 <killme2008.14adfdf8@excelbanter.com> - 2018-01-24 08:11 +0000
Re: Enter value in compute cell location? Gerry Timber <swa2194@gmail.com> - 2018-01-24 03:34 -0800
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-24 09:26 -0600
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 10:37 -0500
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 19:09 -0500
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 19:12 -0500
Re: Enter value in compute cell location? Gerry Timber <swa2194@gmail.com> - 2018-01-24 12:07 -0800
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 19:29 -0500
csiph-web