title: Using Dynamic Named Ranges Created From VBA
body: <p>I have created a series of Dynamic Named Ranges using VBA by creating a copy of a sheet that already contains a series of dynamic named ranges and then renaming the ranges that are automatically generated in the new sheet. All of the new ranges show up in the name manager window <a href="https://i.stack.imgur.com/KChhr.jpg" rel="nofollow noreferrer">Required Named Range</a>. However, I can't seem to use any of the ranges in excel functions. <a href="https://i.stack.imgur.com/iGVGJ.jpg" rel="nofollow noreferrer">Desired Functions</a>. Any Suggestions? </p>
  
  <p>Cheers,
  Rob</p>