3 questions from the last 1 days
-2
votes
1
answer
35
views
Is it true that in Excel VBA, application.cancel will erase the clipboard if it contains a range? [closed]
Long ago, the answer was "yes it is impossible", it was true Why 'Application.Calculation=[value]' statement in Excel VBA erases Clipboard Memory?
But I have implemented a workaround....
- 47
-1
votes
0
answers
50
views
Error message still appears with file lookup in sharepoint despite error handling - VBA Excel [duplicate]
My problem is very similar to this post: Excel error dialogue still pops up even with error handling but the answers did not seem very relevant and so I wanted to re-ask, but I will give more of my ...
0
votes
2
answers
65
views
Excel nested SCAN() formula by columns
I'm using the SCAN() function to build a column vector in which the result depends on the value of each row of the input vector and the prior row of the output vector. The value/accumulator nature of ...
- 1