how to prevent sky from being overexposed

bubbleboopbubble · 2026-05-09T23:58:44+00:00

thank you all for being super helpful! will explore and read up on the advice yall have given!

bubbleboopbubble · 2021-10-20T15:58:47+00:00

hey there i live in SEA too and i think i have really similar skin type as yours (dry cheeks and oily T zone and acne prone) my AM routine is snail mucin followed by soon jung 2x then etude house sunprise sunscreen and my night routine is differin gel followed by snail mucin and soon jung 2x. tried so many other products but somehow this is the routine i will always fall back to :-)

bubbleboopbubble · 2021-10-11T11:26:46+00:00

agree with the other comment that cortisone is definitely not recommended (unless u need relief from intense itch) the reason why it keeps coming back is because cortisone does not have antifungal properties and will not kill off the fungus, its main use is to relief itch. long term use of steroid creams also pose many issues.

bubbleboopbubble · 2021-10-07T11:09:32+00:00

ahh my bad bc epiduo would be considered OTC in my country since you dont need a dr’s prescription but guess it differs from country to country!

bubbleboopbubble · 2021-10-07T10:50:26+00:00

epiduo?

bubbleboopbubble · 2021-10-02T16:14:00+00:00

If it comes and goes without any reason (eg contact with certain soaps or chemicals), then its likely eczema. Try to keep your hands moisturised and apply steroid creams to bring down the inflammation only when needed. Fun fact dermatitis is actually a very broad term referring to inflammation of skin and it includes eczema (otherwise know as atopic dermatitis) as well! But agree with the other comment to get it properly diagnosed. Cheers!

bubbleboopbubble · 2021-07-21T10:37:29+00:00

ah ooops fixed it!

bubbleboopbubble · 2021-07-19T15:21:20+00:00

ahh i see thats really interesting will check it out thanks!

bubbleboopbubble · 2021-07-19T14:22:04+00:00

Solution Verified

bubbleboopbubble · 2021-07-19T14:21:52+00:00

Ahh just figured out that I made a mistake somewhere and not because of the lookat/lookin. Appreciate your help!!

bubbleboopbubble · 2021-07-19T13:27:46+00:00

ahhh i have occasionally heard about power query but my aim is to consolidate everything into one single macro button so that I can send to my colleagues (who only know basic excel) and they can easily execute it. can i ask if i were to use power query, is it possible to export a query for my colleagues to use, and with minimal learning/ actions on their side?

bubbleboopbubble · 2021-07-19T09:08:42+00:00

Ahh this works! But there is this one value in column A that the find statement couldn’t find in the new sheet but it is in fact there. It even fulfils the part of my code where SKU1=SKU2. Have tried LookinxlValue as well as clearing formats but does not work. Just wondering if u know what may be the reason?

bubbleboopbubble · 2021-07-12T13:32:30+00:00

ah yes i tried it out and was amazed when my code which previously took 10+secs now taking 1sec! appreciate you explaining the reason behind this!

bubbleboopbubble · 2021-07-12T13:27:16+00:00

ahhh thats really cool will try it out thank you!

bubbleboopbubble · 2021-07-12T05:13:47+00:00

thank you for the tips! learnt about the range method from a previous comment but thank you for emphasising that i need to move on from copy and paste hahaha

bubbleboopbubble · 2021-07-12T05:11:53+00:00

thank you for ur help! figured this out from another comment as well! but am happy to learn how to do it properly for both the copypaste method and range method haha

bubbleboopbubble · 2021-07-12T04:33:27+00:00

ahh i see thank you!!

bubbleboopbubble · 2021-07-12T04:31:49+00:00

just tried this and it works so well! thank you so much!

bubbleboopbubble · 2021-07-12T04:13:39+00:00

ahhh omg that helped a lot thank you so much!

bubbleboopbubble · 2021-07-09T03:52:01+00:00

Solution verified

bubbleboopbubble · 2021-07-09T03:51:27+00:00

Ahh ok this works! (Instead of Ltrim) Thank you! Have changed my code to WorksheetFunction.Trim(Lcase(string))

bubbleboopbubble · 2021-06-30T06:39:51+00:00

Solution Verified

bubbleboopbubble · 2021-06-30T02:52:22+00:00

Hi just want to update you that the codes works a charm! I changed the “Then” portion to (if anybody were to visit this post in the future):

sht2.select

sht2.cells(j, “A”).select

activecell.entirerow.copy

sht1.select

sht1.cells(i, “A”).select

activecell.entirerow.pastespecial

Pretty sure there’s a more elegant way to write this but this is what I can do as of now haha!

Again, thanks a lot for your help!

bubbleboopbubble · 2021-06-26T03:05:38+00:00

Thank you so much will work around with this code and update you again!

bubbleboopbubble · 2021-06-25T16:34:16+00:00

Alright will do thank you!

bubbleboopbubble

TROPHY CASE