excel-2010 – Tarik Billa

How to call VBA function from Excel cells (2010)?

December 1, 2023 by Tarik

Answer Putting the function in the “ThisWorkbook” area can cause the #NAME? problem. Create a new Module (Right Click on the VBAProject Folder, Insert, New Module) and put the function there instead. Steps Open the VBA Editor (Alt + F11 on Windows / Fn + Option + F11 on a Mac) Right-click VBAProject Select Insert … Read more

Conditional formatting, entire row based

January 29, 2023 by Tarik

Use the “indirect” function on conditional formatting. Select Conditional Formatting Select New Rule Select “Use a Formula to determine which cells to format” Enter the Formula, =INDIRECT(“g”&ROW())=”X” Enter the Format you want (text color, fill color, etc). Select OK to save the new format Open “Manage Rules” in Conditional Formatting Select “This Worksheet” if you … Read more