Help : Macro to name a cell.

[Revathi]

Hi Everyone,

Can someone help me out on the below ..

1. I have 3 tables in sheet1 with the headers from A to F column.

2. I need to name a cell name as "Type" if my next cell name contains as "Data" which will appear anywhere from A to K however i need to repeat the same step for Table 2 and Table 3 headers. Attached snapshot for reference.

Thanks.

 

[mumps]

Cross posted: https://www.excelforum.com/excel-programming-vba-macros/1246526-help-macro-to-name-a-cell.html
Please do not post you question in another Forum without including a link to that thread. See Forum rules here.