VBA to create a named range on each sheet with name of value in cell A2

[milesy29]

Hi there,

First time poster, but long term user of the help on this forum

I'm in need of some help. I have a workbook with 468 sheets of data. Each sheet has a table in the range of A4:AA500. I need to create a named range for each of the table ranges on every sheet and name it as per the value in cell A2 on that sheet to use in Power Query Editor.

So in the end, I would like 468 named ranges, uniquely named as per the cell value in cell A2 on each sheet.

Hope I've described that ok? Please let me know if you need any more clarification.

Any help would be greatly appreciated.

rich

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Ah of course! I've updated the text to remove the spaces, "-"'s and brackets and that now working. Thanks so much for your help