Please advise to make code more efficient to execute
By : user2174633
Date : October 17 2020, 08:10 PM
this will help I'm currently working on a file where data in certain cells are copied and pasted onto another sheet in a table. , Try following sub.
Dim sht1, sht2 As Worksheet
Set sht1 = Worksheets("Sheet1")
Set sht2 = Worksheets("Table")
sht1.Range("K10").Copy sht2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
sht1.Range("G15").Copy sht2.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0)
How do I advise py-execute-buffer in emacs to run py-shell before the function?
By : squidjam
Date : March 29 2020, 07:55 AM
wish help you to fix your issue I'd like to be editing a buffer or file, hit C-c C-c and have the file sent to an IPython session. I can accomplish this now if I first run M-x py-shell before running py-execute-buffer via C-c C-c. But if I try to advise the function via , I think I found some solution: