In addition to the previous post, I would like to be able to call a function
that resides in an add-in from a cell in a spreadsheet.

When I type: =FormatChart(yada, yada, yada....)
into a cell, the function seems to lock up. One of the things about this
function is that is it selects a specific worksheet, and then actually
selects cells in that worksheet. Might this be causing some of my problems?
Should I modify the code so that it only points to the sheet and cells rather
than actually selecting them?

Dale
--
Email address is not valid.
Please reply to newsgroup only.

UDF's used in a worksheet cell can't do things like selecting sheets. They
can't return a value to another cell, either. (Just a warning <bg>.)



Dale Fye wrote:
>
> In addition to the previous post, I would like to be able to call a function
> that resides in an add-in from a cell in a spreadsheet.
>
> When I type: =FormatChart(yada, yada, yada....)
> into a cell, the function seems to lock up. One of the things about this
> function is that is it selects a specific worksheet, and then actually
> selects cells in that worksheet. Might this be causing some of my problems?
> Should I modify the code so that it only points to the sheet and cells rather
> than actually selecting them?
>
> Dale
> --
> Email address is not valid.
> Please reply to newsgroup only.

--

Dave Peterson

> rather than actually selecting them.

Getting out of the Select habit is a very good move. It is almost NEVER
necessary to select anything in VBA. ActiveWindow.FreezePanes = True is the
only time that I can think of that you need to Select anything.

Not using Select will make your code faster and much more maintainable.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Dale Fye" <(E-Mail Removed)> wrote in message
newsB84B5FB-86E3-4217-B102-(E-Mail Removed)...
> Thanks, Dave. I guess I'll have to rewrite the function so that it
> references the worksheets and cells, rather than actually selecting them.
>
> Dale
> --
> Email address is not valid.
> Please reply to newsgroup only.
>
>
> "Dave Peterson" wrote:
>
>> UDF's used in a worksheet cell can't do things like selecting sheets.
>> They
>> can't return a value to another cell, either. (Just a warning <bg>.)
>>
>>
>>
>> Dale Fye wrote:
>> >
>> > In addition to the previous post, I would like to be able to call a
>> > function
>> > that resides in an add-in from a cell in a spreadsheet.
>> >
>> > When I type: =FormatChart(yada, yada, yada....)
>> > into a cell, the function seems to lock up. One of the things about
>> > this
>> > function is that is it selects a specific worksheet, and then actually
>> > selects cells in that worksheet. Might this be causing some of my
>> > problems?
>> > Should I modify the code so that it only points to the sheet and cells
>> > rather
>> > than actually selecting them?
>> >
>> > Dale
>> > --
>> > Email address is not valid.
>> > Please reply to newsgroup only.
>>
>> --
>>
>> Dave Peterson
>>