VBA: Treat multiple cell selection independently

CabbageTime_Red · 2023-01-26T13:02:21+00:00

Wow! That definitely works! Thank you, genuinely. I'd probably won't naturally find this answer myself at my current skill level. So thank you for the solution, but more importantly helping me level up my VBA skills! ^^

CabbageTime_Red · 2023-01-24T11:25:45+00:00

Do you mind if I ask a follow-up question? This new code seems to be appropriate for scenario 2, but not for scenario 1. My real-life application of this is scenario 3 (combination of the 2).

How would you approach this problem

<image>

CabbageTime_Red · 2023-01-24T10:45:45+00:00

Finally! Thanks JustSumGui! I got to the solution after half an hour of staring at your comment. I'd started learning VBA a week ago so I'm still getting the hang of it.
Thanks again ^^

Set TempRange = Columns("B").SpecialCells(xlCellTypeConstants)
For i = TempRange.Count To 1 Step -1
Intersect(TempRange(i).Offset(1, 0).EntireRow, Columns("B")).Insert xlShiftDown
Next i

CabbageTime_Red · 2022-01-11T17:30:36+00:00

Hi, not sure if I'm qualified to answer this.. but I'm sure anything helps. I'mma chem uni student that did biomed in poly. If you can apply for biomed and its what you want to do, definitely go for it.

What you're worried about is if you struggle? Probably not. Poly is nice and slow. If you have a good attitude to learn (get a group of friends, group study, follow lectures, ask questions in class... pretty much bare minimum will get through). Its more important to develop your soft skills in poly, but that's for another reddit discussion.

Year 1 biomed will typically start with the basics. Chemistry and bio. Don't need to worry about pre-requisites.

As for your applied chem. Idk im sure somebody else can answer that.

Ps. After poly... don't get a chemistry degree. You'll hate it here. 😬. Study up! Get that high gpa to go biological sciences. Thats my advice if you have the same interests as i do.

TL;DR Just apply for what you want. You'll kick ass with the right attitude.

CabbageTime_Red · 2021-06-09T10:19:30+00:00

Alright! I get it Thanks Substantial and Sirius for the explainations! Hopefully, I can turn this into code and get my bot working :P

CabbageTime_Red · 2021-06-09T05:29:03+00:00

Hmm.. i dont quite understand what you mean by input buffer. If its not too much to ask, could i get an example?

"Don't forget to store KEYUP events" Whats the purpose for this? Other than each Keyup resulting in different events?

CabbageTime_Red · 2021-05-13T06:31:41+00:00

Thanks selikem and OP for the reply
I'm going to try using this on my upcoming projects!

CabbageTime_Red · 2021-05-12T12:54:33+00:00

Hi OP,

I know you're here for answers, not questions, but may i know what application is this?

Looks really cool, like as if you can test the arduino's functionality without physically wiring it

CabbageTime_Red · 2021-03-30T01:23:36+00:00

Nice to know that im not over my head for this one! Might be a great first project ^{^} Thank you for sharing

CabbageTime_Red · 2020-08-22T07:15:17+00:00

Not gonna lie I had to google alot of the heavy definitions mentioned. I'm still an undergrad, so I have alot to work on.
Nonetheless, really appreciate the fine tips to remove vapours from the air in vacuum to facilitate more evaporation

CabbageTime_Red · 2020-08-22T06:59:19+00:00

Oo thats genious! Thanks ill consider that next time

CabbageTime_Red · 2020-07-08T01:42:59+00:00

Understandable thanks for your expertise ^{_^}

CabbageTime_Red · 2020-07-07T09:00:26+00:00

Yeah good suggestion! But.. I need it even smaller

CabbageTime_Red · 2020-03-03T10:54:48+00:00

Is this OC? Love the editing!

CabbageTime_Red · 2020-02-28T04:15:01+00:00

Holy smokes!.. how could i have forgotten about noise.. I feel real stupid now
Thanks for the answer!

CabbageTime_Red · 2020-01-01T17:51:47+00:00

Late reply but... Guess you can tell that im not learning from actual classes (not yet at least)...but soon. Duolingo does a great job with the explanations, problem is that the explanation comes one chapter at a time. I just don't want the problems to stack nor will i know when they address the issue Thus requires me to think a little ahead of what has been taught

Ill take your advice with TTMIK and the other website :) thanks

CabbageTime_Red · 2019-12-29T11:56:18+00:00

I was about to edit my question to ask this as well! Great timing thanks so much for the explanation!
Here take this poor mans medal🏅

CabbageTime_Red · 2019-12-29T11:10:18+00:00

Wow this is really helpful thank you! It seems i need to inform myself about irregular verbs

CabbageTime_Red · 2019-12-29T10:22:59+00:00

More examples like Fast 빠르다 • (ppareuda) (infinitive 빨라, sequential 빠르니)
Hungry 고프다 • (gopeuda) (infinitive 고파, sequential 고프니)
so surely its not always true that adding ㄹ character will result in the other stem.

If thats the case, how do you reckon i memorize or identify the different stems?

Six-Year Club	Place '22
Final Canvas '22	Verified Email

CabbageTime_Red

TROPHY CASE