Can I not indicate the SheetName from using Write Cell?
The reason I asked that is because, My if condition can check beforehand to decide which sheet to look for (let’s say I have 2 sheets, sheet1 and sheet2, and sheet1 meet the checking criteria) then to extract one cell value from that sheet (shee1 here) and eventually I need to update another one cell value for that particular sheet (sheet1 here). So my process doesn’t really have a moment to stick to an indicated sheet to check & update but to check & update it only after the if condition check.
Any way around to achieve writing cell without indicating the SheetName specifically?
Such as applying a generic value to the SheetName etc.