'Position chart according to a dynamic positioning table

Relatively new to VB

I have multiple charts generating macro which positions the carts according to this code:

ActiveSheet.Range(B100:H125) 

Each chart has its own position and they are drawn one after the other in a printable format on an excel sheet.

Now, trying to modify it and for practical reasons trying to create a table with the new locations of the chart.

How can I take a cell value from excel and add it to the range?

for example

Range("B" and the cell value from the table with the top left row number:H and the cell value from the table with the bottom right row number)


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source