Cycle Through Specific Worksheets & Paste Data In Each Sheet

I need assistance with a way to cycle through many numerically named worksheets (over 300) and paste data in the same cell (ie "A18") on each sheet. I have a large workbook that contains many sheets that are a mix of string named and numerically named sheets. I want to exclude string named worksheets in this workbook.

1) Need to loop through ALL numerically named sheets only and paste data (named range) in the same cell location on each sheet.

2) I have formulas and links that are included in the special paste.

Your assistance is greatly appreciated.

Try something like this. Change the Sheet name and Named Range to suit.

Please Login or Register  to view this content.

Ran subroutine. Did not work. Numerically named sheets are like 1-1-1, 2-18-2, 3-24-1. I have to subroutine stored in same workbook.

[SOLVED] You are awesome! It worked great. Thanks a bunch for your help. Happy Holidays...