Runtime error 1004 Method 'Range' of object_ Global Failed

Originally Posted by xladept

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.