I am trying to look through worksheets copying one area to the sheet and then onto the next sheet.
My problem is that the copying cell references are all on a table on sheet1.
Tried to put this together, my excel habits of nesting may be getting in the way. Can I receive assistance?
Code
For x = 3 To Sheets.Count
Worksheets("sheet" & x).Activate
Range(Sheet1.Range(.Cells((42 + x - 3), 6).Value, .Cells((42 + x - 3), 7).Value)).Copy
Sheets(CStr(rSheets(x, 1))).Cells(3, CStr(rSheets(x, 2))).PasteSpecial xlValues
Sheets(CStr(rSheets(x, 1))).Cells(3, CStr(rSheets(x, 2))).PasteSpecial xlPasteColumnWidths
Next x