Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    262

    Well done Microsoft :mad:

    Well done Microsoft :mad:
  2. Replies
    8
    Views
    262

    I understand that but I'm still annoyed because...

    I understand that but I'm still annoyed because the PDF file opens in Word (online) and not in Acrobat Reader. Even for the non-original account (but that account too has Office 365). I wonder what...
  3. Replies
    8
    Views
    262

    Yes I do. When the link is accessed from another...

    Yes I do. When the link is accessed from another account, the "edit in word" button is not there.
    I still find the behaviour strange, especially because the link was created as read-only.
  4. Replies
    8
    Views
    262

    Onedrive and PDF read only files

    I created a PDF file (save as PDF in word) and saved it to my OneDrive storage.
    I then created a read only link for that file
    When the link is clicked, the file opens in Word Online
    and worse:...
  5. Replies
    2
    Views
    122

    Nope. Works only for Windows (and Mac), not for...

    Nope. Works only for Windows (and Mac), not for iPads.:(
  6. Replies
    3
    Views
    130

    I found the problem: in the 'Protect sheet' pop...

    I found the problem: in the 'Protect sheet' pop up window, I had unchecked 'select locked cells', because I mistakenly thought you would then be able to change that cell.
  7. Replies
    2
    Views
    122

    Office Language on iPad

    I recently bought an iPad Pro - which came pre-installed with the Dutch language. Which is fine for me. However, I want to install Office 365 (especially EXCEL) with the English language (as...
  8. Replies
    3
    Views
    130

    Goal Seek and Locked cells

    Is it possible to have a locked cell as the 'Set Cell' of a Goal Seek?

    The 'Set Cell' contains a worksheet formula that I don't want to be destroyed, so I protected the worksheet (which in turn...
  9. Opening an Encrypted Access Database in VBA

    Access data base created with access 2010, encrypted and opened in access 2016
    Following code is used (in EXCEL) to open the data base:

    Dim strProvider As String
    strProvider =...
  10. Replies
    11
    Views
    2,252

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

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

    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)...
  12. Replies
    11
    Views
    2,252

    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...
  13. Replies
    11
    Views
    2,252

    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: ...
  14. Replies
    11
    Views
    2,252

    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
  15. Replies
    11
    Views
    1,404

    @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...
  16. Replies
    11
    Views
    1,404

    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...
  17. Replies
    11
    Views
    1,404

    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...
  18. Replies
    19
    Views
    3,708

    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
  19. Replies
    19
    Views
    3,708

    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.
  20. Replies
    19
    Views
    3,708

    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.
  21. Replies
    19
    Views
    3,708

    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...
  22. Replies
    19
    Views
    3,708

    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...
  23. Replies
    3
    Views
    1,380

    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...
  24. 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
  25. Replies
    3
    Views
    1,380

    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...
Results 1 to 25 of 117
Page 1 of 5 1 2 3 4