Hi there,

I need a basic VBA that will adjust the size of all charts in the worksheet based on the value in A1 cell.

IF A1=5 H - 5" W - 15"
IF A1=10 H - 10" W - 15"
IF A1=20 H - 20" W - 15"
IF A1=50 H - 40" W - 15"