I know this should be much easier than I'm making it. I'm simply tring to loop through all existing sheets in one workbook and paste a section from a "Master" tab into each sheet. Something like:
But Sheet1, Sheet2, Sheet3 is an unlimited number of sheets. I've done formating using:
For Each Sht In Sheets
but I can't seem to paste a range correctly. Help I've been trying for 3 hours and I'm totaly brain dead...THANK YOU!!!
Thanks for trying but it's not working (even after correcting the minor typo of "Net Sht" to Next Sht. I'm still getting an error on sheets(sht).Select which seems to be the heart of my problem. I don't now how to select each "Sht" without calling it by actual tab name, not a variable