Selecting Range will not work

Question

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!

Answer 1

Hi Viorel-1

Thank you for your reply.

I'm not sure what you mean, sorry.

Range(Cells(9, 1), Cells(x + 4, y - 2)).Select = Range(Cells(9,1),Cells(57,43)).Select

So I don't see why selecting this range is not valid.

Thanks

Answer 2

I just tried this... and got the same error:

Range("A1").Select

On the activesheet... ByStartDate .... I have just pastedspecial the values and formats so there is an active range that is highlighted. Does that have anything to do with it?

Thanks

Answer 3

I ran a test in a brand new workbook and the code works fine, so it must be my workbook. I tried a open and repair but that has not fixed anything.

Thanks