Timeline for Tips for golfing in VBA
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 7, 2018 at 18:50 | comment | added | seadoggie01 | Does this work with Match? I tried, but it always returns errors. I was passing an array instead of a range, though. | |
| Sep 25, 2017 at 19:24 | history | edited | Taylor Raine | CC BY-SA 3.0 |
added 13 characters in body
|
| Aug 3, 2017 at 20:38 | comment | added | Greedo | @TaylorScott So you can, I was totally unaware that you could set/ hold values in variables that weren't already defined, but I suppose that's because I'm still getting to grips with the Immediate window 1-liners. Have updated accordingly | |
| Aug 3, 2017 at 20:35 | history | edited | Greedo | CC BY-SA 3.0 |
Corrected mistake in array usage
|
| Aug 3, 2017 at 12:39 | comment | added | Taylor Raine |
Actually the last section on arrays is a bit off - it can be used in the immediate window i=[ROW(A1:A5)]:v=i(2,1):?v
|
|
| Aug 3, 2017 at 11:19 | comment | added | Greedo | Sorry for the mammoth post, if anyone feels they can make areas more concise/ if you have tips to add, then feel free. Also, although I researched some of this, a fair portion was found through experimenting in VBA, so if you spot mistakes of feel there's something missing, don't hesitate to comment/edit accordingly! | |
| Aug 3, 2017 at 11:17 | history | answered | Greedo | CC BY-SA 3.0 |