Error 1004 when using Range(Cells(1,1),Cells(2,2)) format.

Hi all,

I'm almost certain this has been answered before but couldn't for the life of me find a solved post on this... my code is below but when I run it I get:

'Run-time error '1004': Application-defined or object defined error'.

Code:

Please Login or Register  to view this content.

The tablerows and rawrows integer values are 1178 and 100 respectively.

I'm certain there's an easy solution to this but I've been stressing over this for hours and I'm on the verge of a mental breakdown - any help would be greatly appreciated.

Cheers,

Chris

I'm hoping the "select" thing is just for the sake of this question. In VBA you almost never need to "select" something prior to acting on it, only humans need to do that, VBA does not. Anyway, my suggestion:

Please Login or Register  to view this content.

@TheClaw2323, Jerry's code might have solved your issue but if not are you sure the error isn't 'Run-time error '1004': Select method of Range class failed' and is Worksheets("Sold & Confirmed Unsold") the activesheet (I am assuming the Select was actually in your actual code)?