Image Custom Heatmap in Excel using Macros

Tutorial on creating custom user-defined heatmap regions on an image using Macro-enabled excel workbook.
NOTE: macros are not functional on GoogleSheets or OnlineExcel

[@eleashaxox8158]

Hello, thank you for the video. Really helpful. I am coming across an issue with running the macro.
ActiveSheet.Shapes(Range("actlocation").Value).Fill.ForeColor.RGB = _
Range(Range("actcolourcode").Value).Interior.Color
The above code is constantly being highlighted and coming up as an error saying 'Run time error'1004'. Method 'Range; of object'_Global' failed. Was just wondering if you could please help with this.

[@yeahx32p69]

have you solved this issue? Did you try indexing the second line?

[@munkie2003]

I have the same issue, how did you overcome this?

[@8dasc]

Same here. Has someone found a solution?

[@om8367]

Did anyone get it ryt?

[@ericroodhooft973]

Dear, thank you for the tutorial, but could you help me, I created the macro as described in your video. But when I try to run it, I always get the following error message
error -2147024809 (80070057) during execution
The item with the specified name was found nit
ActiveSheet.Shapes(Range("actlocation"). Value). Fill.ForeColor.RGB = _
Range(Range("actcolorcode"). Value). Interior.color

[@yeahx32p69]

Thank you so much for this. Finally, I and my buddies can use this for our workouts. (More pain = more muscle gain in those body regions). Just have to record more data from the weight scale for higher accuracy.
Going to use this for medical reasons as well for older folks. Can reveal patterns maybe. Using those patterns, future issues could be avoided too.
I'm really thankful for what you have shown. It was so simple and to the point. Really helpful. Looking forward to more interesting things you show.

[@SergioMCoach]

Thaaaank you :)

[@0x647A]

awesome!