I want the copy and paste (ideally paste values) to apply to specific ranges (the copy and paste ranges are not the same) and to certain sheets only in the workbook. The loop works well in other macro's, I suspect the the copy and paste is the problem. Any assistance would be appreciated, thank you.
|Dim b As Worksheet|
|For Each b In ThisWorkbook.Worksheets|
|If b.Name <> "Setup" And b.Name <> "Soil Report" And b.Name <> "Soil Test" And b.Visible Then|
|range("B10:E36").Value = range("A10:D36").Value|