selecting range A1:B2

[ammartino44]

Hello. I have data with A1:B2 and that's it. Why isn't this code capturing that?

Please Login or Register  to view this content.

Thanks.

[gmr4evr1]

Are you trying to select, copy or both, A1 and B2? Your code is set to select/copy A1 and B1.

[ammartino44]

What do you mean? It's supposed to capture the last row in B, which is B2, so the range should be A1 to B2. Below is complete code.

Please Login or Register  to view this content.

[gmr4evr1]

You are right, I didn't have anything in cell B2 so it didn't select it, once I did put a value in B2, the copy part of the code worked. However, I couldn't get the Paste part of the code to work until I changed Sheets(s + 1) to Sheets("Sheet2"). I'm guessing I'm missing something with the s + 1 part.

[ammartino44]

I changed it to sheet2 as well and it still doesn't work. It just copies the first row from income statement twice. The s+1 just creates a new sheet.

[stnkynts]

When using the Cells property you need to also reference the sheet. A lack of a reference indicates the Activesheet which may or may not be correct.

Please Login or Register  to view this content.

Note: The s+1 does not create a new sheet unless you are acutally creating a new sheet in code we cannot see.

[ammartino44]

I tried using this and I also got an error. @ stinky, I'll try your code in a second.

[ammartino44]

@ stinky, your code works. How could I do it with two ranges instead of that last cell piece?

[stnkynts]

How could I do it with two ranges instead of that last cell piece?

I am not sure I understand what you mean. Do you mean like this?

Please Login or Register  to view this content.