Search:

Type: Posts; User: rvWoody; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    11
    Views
    850

    But 'formula' cells do not trigger a change...

    But 'formula' cells do not trigger a change event? There is something I don't undderstand.
  2. Replies
    11
    Views
    850

    The 'final' code posted above suffered in a...

    The 'final' code posted above suffered in a reality check from two major problems:
    1. The change event is not fired for a calculated value. In the real spreadsheet, the Alpha cells contain a (user)...
  3. Replies
    11
    Views
    850

    The sample code above changes all sparklines in...

    The sample code above changes all sparklines in the Trend column, whether Alpha has been changed or not. It also contains cell references and depends on the Trend cell being located in front and...
  4. Replies
    11
    Views
    850

    I adapted the solution zeddy offered. It was not...

    I adapted the solution zeddy offered. It was not clear in the Original question that the data were arranged in a table. Therefore, I had to Ungroup the Sparklines to make it work: ...
  5. Replies
    11
    Views
    850

    Sparklines: Conditional formatting?

    Is it possible to colour the sparklines based on a value in another column (e.g. C - When positive: Green, Negative: Red, Otherwise: Neutral blue)?

    43124
  6. Replies
    11
    Views
    590

    @Rory: this is indeed an elegant way to achieve...

    @Rory: this is indeed an elegant way to achieve the desired result. Congratulations.

    However, I have to stick with a (modified) UDF. As you observed the NULLs spoil everything. To further...
  7. Replies
    11
    Views
    590

    Thanks for your replies. I was already afraid...

    Thanks for your replies. I was already afraid that no compact solution could be found within the set of Excel functions. What further complicated the issue was the presence of Nulls in the data set...
  8. Replies
    11
    Views
    590

    Counting inequalities

    Following table was pulled from an SQL Server data base and shows dividends paid over the past years.

    42847

    I want to count how many times the dividend was at least equal or greater than that...
  9. Replies
    19
    Views
    2,124

    I can't insert a symbol into a Name. I get all...

    I can't insert a symbol into a Name. I get all shades of Grey :( - see attachment

    41658
  10. Replies
    19
    Views
    2,124

    zeddy, I do consider a named range as a...

    zeddy, I do consider a named range as a reference. I do agree that the use of a name is less error prone.
  11. Replies
    19
    Views
    2,124

    Thanks again to all: copying a reference to a...

    Thanks again to all: copying a reference to a spreadsheet cell that contains the symbol and constructing the formula around it in the formula bar does the job.
  12. Replies
    19
    Views
    2,124

    Thanks to all for replying so quickly. The...

    Thanks to all for replying so quickly.

    The most straightforword solution would be the use of Maudibe's suggestion: =IF(ERROR.TYPE(A1)=2,"∞"), but if I try to insert the ∞ symbol (from the math...
  13. Replies
    19
    Views
    2,124

    The road to infinity

    Is it possible to represent the symbol for infinty as result of a calculation? I want someting like this:
    IFERROR (some calculation, "Symbol for infinity")
    The following article seems to suggest...
  14. Replies
    3
    Views
    709

    The more generic question can be solved by using...

    The more generic question can be solved by using dynamic SQL. Interpreting some googled results, I put the following reminder to myself together:

    Generic Approach

    1. Define an SQL variable...
  15. You must add a Parameter object before executing...

    You must add a Parameter object before executing the query. Examples of how to do so can be found at:
    VBA,ADO connection an query parameters
    or
    How to invoke a parameterized query using VBA
  16. Replies
    3
    Views
    709

    Yes, I did and got the same error. Following...

    Yes, I did and got the same error.

    Following code did circumvent the problem:

    SELECT Code,
    Name,
    ISNULL([2012],0) as [2012],
    ISNULL([2013],0) as [2013],
    ISNULL([2014],0) as [2014]
    FROM...
  17. Replies
    3
    Views
    709

    Struggling with t-SQL PIVOT

    Following code works perfectly with my SQL Server 2008R2 data base:

    SELECT Code,
    Name,
    [2012] as [2012],
    [2013] as [2013],
    [2014] as [2014]
    FROM (SELECT C.Code,C.Name,D.DivYear,D.Amount...
  18. Thread: Table Headers

    by rvWoody
    Replies
    2
    Views
    307

    Table Headers

    38607

    Attached image shows a table that contains a column with sparklines. As I have no need to sort the sparklines (nor the data columns D to G, for that matter) I want to remove the inverted...
  19. Replies
    4
    Views
    621

    Thanks to all of you for your useful suggestions....

    Thanks to all of you for your useful suggestions. For sure: if it ain't broke, don't fix it, but repeatedly being remembered of that update almost made me feel guilty. It won't (probably) happen...
  20. Replies
    4
    Views
    621

    Remove Automatic Update Warnings?

    Last week-end, I installed an optional update (nvidia - Graphics Adapter WDDM1.1, ...), suggested by Windows Update. What a catastrophe! My system (Win7/32) almost immediately stalled every 10-15...
  21. Replies
    10
    Views
    7,886

    It didn't but in an unexpected way: In fact, the...

    It didn't but in an unexpected way: In fact, the form was displayed as it was laid out at design time. It happens to be a form where the controls are dynamically put in place when the form is...
  22. Replies
    5
    Views
    1,343

    Try...

    Try [tblValuations]![CreateValuation]>=[reportdate] and [tblValuations]![CreateValuation]<=[reportdate2]
  23. Replies
    10
    Views
    7,886

    Thanks rory: that did it. After reading your...

    Thanks rory: that did it. After reading your answer, the error message was clear and rather explicit!

    PS: If ever I switch to office 64-bit, would it be sufficient to change "user32" for...
  24. Replies
    10
    Views
    7,886

    @rory: thanks for your reply. Unfortunately, it...

    @rory: thanks for your reply. Unfortunately, it does not work.

    But let me briefly describe the pretty standard application. When access is opened it performs some actions (retrievals) on the...
  25. Replies
    10
    Views
    7,886

    Adding Select doesn't put Excel on top in the...

    Adding Select doesn't put Excel on top in the Office 2010/Win7 environment. Sorry.
Results 1 to 25 of 108
Page 1 of 5 1 2 3 4