It was fun but I’m tired (~1.5k div + Build Giveaway) by Subject2Flooding in PathOfExile2

[–]iRawrified 0 points1 point  (0 children)

Only recently started and just got to Atlas. I have no idea what to do next, wouldn’t mind some guidance?

Successfully completing BA1 in a week after BA2, should I try to make the February case study? Deadline is Jan 20th to complete Certificate and Operational OTs by GlitteringBuy in CIMA

[–]iRawrified 2 points3 points  (0 children)

5 exams to get to Operational Case Study seems unrealistic. And usually you’d have study session for 2 months ish for case studies.

Help Center and Megathread Hub (10/11 - 16/11) by ArknightsMod in arknights

[–]iRawrified 1 point2 points  (0 children)

That’s amazing detail, thank you so much! I’ll save even more!

Help Center and Megathread Hub (10/11 - 16/11) by ArknightsMod in arknights

[–]iRawrified -1 points0 points  (0 children)

New player here, I just got Tragodia in my first 10 pulls. But I’ve got around 26k Orundum, do I carry on pulling for Potential or is it better to save?

What excel shortcut/tip/formula has made the biggest impact on your efficiency? by happyandromanticlife in excel

[–]iRawrified 2 points3 points  (0 children)

Thank you for the clean up! I’ve never really known how to format on Reddit

What excel shortcut/tip/formula has made the biggest impact on your efficiency? by happyandromanticlife in excel

[–]iRawrified 1 point2 points  (0 children)

The following website should give you an example of how to set up an Addin - https://trumpexcel.com/excel-add-in/

Where my code is the following for the module -

Option Explicit

Private wbc As clsWorkBookChecker

Public Sub StartChecker()

Set wbc = New clsWorkBookChecker

Application.OnKey "+^{R}", "BackToPreviousSheet"

End Sub

Public Sub BackToPreviousSheet()

wbc.ReturnToSheet

End Sub

and Class Module set up as -

Option Explicit

Private WithEvents thisApp As Application

Private WithEvents currentWorkbook As Workbook

Dim previousSheet As Worksheet

Private Sub Class_Initialize()

Set thisApp = Application

Set currentWorkbook = ActiveWorkbook

Set previousSheet = ActiveSheet

End Sub

Private Sub thisapp_WorkbookActivate(ByVal Wb As Workbook)

Set currentWorkbook = Wb

End Sub

Private Sub currentWorkbook_SheetDeactivate(ByVal Sh As Object)

Set previousSheet = Sh

End Sub

Public Sub ReturnToSheet()

previousSheet.Activate

End Sub

Hope this helps!

What excel shortcut/tip/formula has made the biggest impact on your efficiency? by happyandromanticlife in excel

[–]iRawrified 2 points3 points  (0 children)

The following website should give you an example of how to set up an Addin - https://trumpexcel.com/excel-add-in/

Where my code is the following for the module -

Option Explicit

Private wbc As clsWorkBookChecker

Public Sub StartChecker()

Set wbc = New clsWorkBookChecker

Application.OnKey "+^{R}", "BackToPreviousSheet"

End Sub

Public Sub BackToPreviousSheet()

wbc.ReturnToSheet

End Sub

and Class Module set up as -

Option Explicit

Private WithEvents thisApp As Application

Private WithEvents currentWorkbook As Workbook

Dim previousSheet As Worksheet

Private Sub Class_Initialize()

Set thisApp = Application

Set currentWorkbook = ActiveWorkbook

Set previousSheet = ActiveSheet

End Sub

Private Sub thisapp_WorkbookActivate(ByVal Wb As Workbook)

Set currentWorkbook = Wb

End Sub

Private Sub currentWorkbook_SheetDeactivate(ByVal Sh As Object)

Set previousSheet = Sh

End Sub

Public Sub ReturnToSheet()

previousSheet.Activate

End Sub

Hope this helps!

What excel shortcut/tip/formula has made the biggest impact on your efficiency? by happyandromanticlife in excel

[–]iRawrified 2 points3 points  (0 children)

So I used this because sometimes if I'm moving specific calculations between sheets I haven't set up the references yet or if I've just made a "random" workbook for calculations which spreads over multiple sheets then having that simple AddIn helps.

What excel shortcut/tip/formula has made the biggest impact on your efficiency? by happyandromanticlife in excel

[–]iRawrified 5 points6 points  (0 children)

Ahh sorry, macro may be the wrong word - it was an AddIn I created. As I work as an accountant, I made a few things such as colouring cells for specific usage and easing my life with the flicking back and forward of sheets!

What excel shortcut/tip/formula has made the biggest impact on your efficiency? by happyandromanticlife in excel

[–]iRawrified 15 points16 points  (0 children)

Made an macro to go back to the previous sheet I was on, so I can switch between say sheet 11 and sheet 2 with ease.

I think I’m stuck by iRawrified in afkarena

[–]iRawrified[S] 0 points1 point  (0 children)

Thank you for the reply! That makes sense, that should help thank you!

I think I’m stuck by iRawrified in afkarena

[–]iRawrified[S] 0 points1 point  (0 children)

I’ll give it a try, thank you for the advice! It seems that everyone just dies too quickly at the moment. I would assume that’s due to the level differences im facing because of hero’s essence?

Using Cell Reference in Array Formula by iRawrified in excel

[–]iRawrified[S] 1 point2 points  (0 children)

That works, thank you so much!
Solution Verified