Cycle Through A Series of Worksheets & Insert Rows, Then Special Paste Data

Good afternoon, I need assistance with the following:

1) I have many worksheets that I need to cycle through - only the ones’ that read “wk1 thru wk52.”
2) I need to loop through WK1 thru WK52 only and insert 23 rows in the same cell (A64) on each sheet.
3) Then, I need to copy a range name “Weekly_Add_Data” (A87:AA109) - goes to the clipboard.
4) Lastly, I need to Special Paste (all – formats, formulas, links, etc.) range name – “Weekly_Add_Data” back to cell A64.

Your assistance with this, is greatly appreciated.

I can help you with the first one

Please Login or Register  to view this content.

Thanks a bunch for your contribution. I will test now.

Hello AB33,

I ran and tested above subroutine. It kicked an error, so I declared "sh" as an Object Variable. When I tested again on my test workbook, it ran but did nothing to the sheets.

Well, I have tested it on sample and did work. Declaring Object Variable should not make any difference to running of the code. I think it would be easy for us to test the code if you could attach a sample of your book. We are working from your description, but not actual data.

Attached is the requested file.Upload - Test Line 1 Data.xlsm

I will have a look, but i know the issue- case senstive. I had lower case and you have upper case

This should work. Sorry, earlier you were right on variables as you have option explict on your code

Please Login or Register  to view this content.

It worked great! Thanks a bunch to both of you for your expertise. You are excellent inspiration.