In the lines where you set the ranges, these are referring to specific cells, not entire columns. Instead of: Set MDART_G2 = wb2.Sheets("2. Référenciel Article").Range("C7") Set MDART_CODE = wb2.Sheets("2. Référenciel Article").Range("C1") Try this: Steve_SumProductCom Tha...
Maybe The Secret Life of Walter Mitty that’s playing in the background is seeping into my pores and challenging me to bust out of my comfort zone. Perhaps I need to write a listicle on “10 Ways To Be More Adventurous”, “Top 5 Heart Desires”, “Journal Instead of Blogging – 3...
main1.dart and main1_test.dart - test_driver/main1.dart # Interim location of screenshots from tests staging: /tmp/screenshots # A list of locales supported by the app locales: - en-US # A map of devices to emulate devices: android: Nexus 5X: frame: true ...
Reading this list, I realized how many tics I have. Constantly shifting weight, always sitting on the edge of my chair, mindlessly peeling labels from bottles, bouncing my leg while sitting, fast walking, swinging my arms as I walk, hooking my thumbs in my pockets, pulling on my lower li...
Range("B2:B" & NBrow1).FormulaR1C1 = "=INDEX(" & MDART_G2.Address(External:=True) & ",MATCH(RC1," & MDART_CODE.Address(External:=True) & ",0))" Thank you in advance for your support. Anthony CODE: Sub Reformatage_report_G2_AFO_TEST() ...