Thank you for taking the time to read my question.
I have the following code. The first Range(cells(),cells()).select works, but the second one will not. I'm at a total loss as to why. Any help would be great.
Range(Cells(1, WBSCol), Cells(x, y)).Select
Selection.Copy
Sheets("ByStartDate").Select
ActiveSheet.Range("A4").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
ActiveSheet.Range("A4").Select
Selection.PasteSpecial Paste:=xlPasteFormats
Range(Cells(9, 1), Cells(x + 4, y - 2)).Select
"1004, Select Method of Range class failed"
Thanks!