Serving the Quantitative Finance Community
Excel tricks
Depends on the task at hand, the person and how you define quant finance.
Excel tricks
hi all. well ... once again i got a loop in my vba code causing excel to block. excel restarted but only part of my code was recovered.beside saving the file ** each time ** before launching a macro, are there simple 'security' measures to respect? maybe adding few lines such as 'after x minutes, whatever, stop working' (anyway how to say that to excel?)
-
- Cuchulainn
- Posts: 22931
- Joined:
Excel tricks
QuoteOriginally posted by: outrunI always click save before I click play. Sometimes my macros barf crap all over my sheet because of a little typo.Like 1) crtl S 2) Save all etc.!
Excel tricks
QuoteOriginally posted by: CuchulainnQuoteOriginally posted by: outrunI always click save before I click play. Sometimes my macros barf crap all over my sheet because of a little typo.Like 1) crtl S 2) Save all etc.!i sure agree with these advises. the point is that i often click 'GO' and realize afterwards i didn't save all.maybe a solution is to include few lines before my actual code, such as Dim Wk As Workbook, Wk.Save
Last edited by tags on November 12th, 2012, 11:00 pm, edited 1 time in total.
Excel tricks
QuoteOriginally posted by: edouardQuoteOriginally posted by: CuchulainnQuoteOriginally posted by: outrunI always click save before I click play. Sometimes my macros barf crap all over my sheet because of a little typo.Like 1) crtl S 2) Save all etc.!i sure agree with these advises. the point is that i often click 'GO' and realize afterwards i didn't save all.maybe a solution is to include few lines before my actual code, such as Dim Wk As Workbook, Wk.Save pfffffffffffff, that just saved my lifes guy and i hate the GUI (?) of excel VBA.
-
- Traden4Alpha
- Posts: 3300
- Joined:
Excel tricks
QuoteOriginally posted by: outrunthis is handy for *dynamic* sorting a range in Excel (without VBA of course)Awesome! I need this functionality for doing quick-and-dirty CDFs and analyses of residuals. Thanks!
Excel tricks
QuoteOriginally posted by: Traden4AlphaQuoteOriginally posted by: outrunthis is handy for *dynamic* sorting a range in Excel (without VBA of course)Awesome! I need this functionality for doing quick-and-dirty CDFs and analyses of residuals. Thanks!strange, the link above worked this morn. now, i only can access a a cache version of the page.
Excel tricks
this is boring manually commenting one line after another in Excel is there a way to comment several lines of code at a time?
Excel tricks
Yes, there are Comment Block and Uncomment Block commands available in the Excel Visual Basic editor. They are part of the Edit toolbar, make sure that is visible.
Excel tricks
QuoteOriginally posted by: DavidJNYes, there are Comment Block and Uncomment Block commands available in the Excel Visual Basic editor. They are part of the Edit toolbar, make sure that is visible.cool, thx.