Timeline for Custom sorting an Excel Data Table (+ visual formatting)
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 20, 2016 at 18:29 | vote | accept | Kaz | ||
| Dec 11, 2015 at 15:07 | comment | added | Kaz | I feel like we're getting into a more general discussion here. If you want, we could move it to a chatroom? | |
| Dec 11, 2015 at 15:04 | comment | added | Kaz | Do you have a mental list of every single range method and which will fail if manipulating a non-active range? I know I don't. So, why spend all the time checking every operation in my functions when I can just activate the sheet and not have to worry about it? | |
| Dec 11, 2015 at 14:56 | comment | added | Raystafarian |
No, I'm saying since you're specifying that, you don't need activate. If you haven't seen it, this may help.
|
|
| Dec 11, 2015 at 14:14 | comment | added | Kaz | I'm specifying a range and the sheet on which it resides. What more do you expect me to specify? | |
| Dec 11, 2015 at 11:57 | comment | added | Raystafarian |
Right, but you shouldn't be doing anything without specifying what you're doing it to, so .activate becomes irrelevant.
|
|
| Dec 10, 2015 at 19:52 | comment | added | Kaz | Sure, but if you try and do certain things to ranges that are on sheets that are out of focus, the code will throw an error and stop executing. I'd rather avoid that happening. | |
| Dec 10, 2015 at 19:25 | comment | added | Raystafarian | The thing is, say you're working with searchrange or tablerange, they are already defined as that sheet. | |
| Dec 10, 2015 at 19:24 | comment | added | Kaz | If my function isn't activating the sheet, then it is *implicitly* assuming that the sheet is *already* activated. Why make assumptions you don't have to. | |
| Dec 10, 2015 at 18:56 | answer | added | Raystafarian | timeline score: 3 | |
| Dec 9, 2015 at 11:45 | history | edited | Kaz | CC BY-SA 3.0 |
added 3468 characters in body
|
| Dec 9, 2015 at 9:36 | comment | added | Kaz | @Raystafarian Need? No. But I prefer not to make assumptions I don't have to. | |
| Dec 9, 2015 at 2:51 | history | tweeted | twitter.com/StackCodeReview/status/674420972833923072 | ||
| Dec 8, 2015 at 17:28 | comment | added | Raystafarian |
Also, most of the comments tell the reader what's happening, rather than why it's happening or what it's accomplishing and how it's being accomplished. Also, I too am puzzled by the need for Cvar
|
|
| Dec 8, 2015 at 17:21 | comment | added | Raystafarian |
Is there a reason you need any of those .Activates?
|
|
| Dec 8, 2015 at 13:48 | history | asked | Kaz | CC BY-SA 3.0 |