Runtime error 1004 Method 'Range' of object_ Global Failed

[stevoDE]

Can someone please tell me why this code is failing?

Please Login or Register  to view this content.

*edit* I = 1 to .rows.count and not 8

[Special-K]

Please ignore this reply.

[xladept]

You can't resize <1 and you can't offset -2 from the second column; is what immediately "pops out"

[Special-K]

Darn, I wish I'd kept my reply now

[xlnitwit]

Hi,

You need Cells, not Range if you want to pass a row and column argument like that, and the size and offset are wrong.

Did you mean to start your loop from B15?

[xladept]

@ Special-K You can reinstate your reply - we won't care and we'd like to see it

[stevoDE]

You can't resize <1 and you can't offset -2 from the second column; is what immediately "pops out"

I'm offsetting -2 rows from the last used row starting from the bottom, not from the second column. I'm not sure what you mean about resize <1.

I have edited my code as 'i' should have been 1. I'm basically trying to check if the value in column H is blank. If it is not, I want to copy that row from column B to H i.e. H resized by -7 columns.

[xladept]

Please Login or Register  to view this content.

????


I was wrong about the column offset as it's, obviously, a row offset.

Offset and resize do not work the same way, Resize(0,-7) is

defining a zero rows and negative 7 columns - it can never was:|

[stevoDE]

Please Login or Register  to view this content.

????


I was wrong about the column offset as it's, obviously, a row offset.

Offset and resize do not work the same way, Resize(0,-7) is

defining a zero rows and negative 7 columns - it can never was:|

With you now, I wasn't aware you couldn't resize to the left.

The above doesn't seem to do what I'm after and that's probably because I didn't mention that I want to copy all rows (equivalent of holding down the CTRL key and copying). The above code only copies the last row where the value in column H is not blank.

[xladept]

Try this:

Please Login or Register  to view this content.

[stevoDE]

Please ignore.

[stevoDE]

Try this:

Please Login or Register  to view this content.

This works. I was looking to only copy the columns (i.e. B:H) within my specified range as opposed to the entire row but I managed to fix that myself.

Thanks!

[xladept]

Try:

Please Login or Register  to view this content.