Re: formula refresh problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

UDFs are automatically refreshed if you follow the advice to include all input to the function in the argument list.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BoringAccountant" <jblayd@xxxxxxxxxxx> wrote in message news:1193941236.966589.152920@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| Background:
|
| I have a series of user-defined functions exposed as formulas within
| Excel. They are being refreshed using the .CalculateFull method when a
| user presses a command button on the right-click command bar.
|
| They also have the option of using the F2 shortcut key to show the
| cell contents of the formula and then pressing "enter" to refresh
| formula within the single cell. To determine target cell in this case
| is fairly easy. You can use the Application.ActiveCell.Formula
|
| How can I determine which cell is the "ActiveCell" when a user invokes
| the .CalculateFull method? The normal Application.ActiveCell.Formula
| does not work and only returns the same cell where the cursor was
| located when the .CalculateFull method was first invoked.
|
| I am using VB 6.0 and programming against the Excel 2003 Object Model.
|
| Any guidance would be appreciated!!!
|


.

Relevant Pages

  • Re: Merging from Excel
    ... messages from Excel that I don't remember in previous versions. ... If you use Alt-F9 to view the underlying field codes, ... Yes, at best the data will refresh if you go into Word Mailings etc., open ... I don't think cell reference syntax lets you specify a cell by ...
    (microsoft.public.word.mailmerge.fields)
  • Re: refresh all cells in column
    ... Microsoft MVP - Excel ... "jenn" wrote in message ... > every cell in a column at once? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Popup to show ongoing activity
    ... Microsoft Excel 2000 Power Programming with VBA ... Then close the userform when the code completes. ... The hang-up may be if the userform code doesn't wait for the refresh to complete. ... there is a cell which always changes at the end of the refresh so that would be ...
    (microsoft.public.excel.misc)
  • re-execute vba function
    ... I have create a function in excel using vba and I would like to refresh that ... function without going in each cell and press enter. ...
    (microsoft.public.excel.programming)
  • Re: Output form to excel with range ????
    ... here is a long post with lots of useful code for exporting to excel. ... Dim varGetFileName As Variant 'File Name with Full Path ... Set objXLws = objXLWkb.ActiveSheet ... For Each cell In objXLws.Range ...
    (microsoft.public.access.formscoding)