Object required error

[SoMeOnE31619]

Hi Guys, I am trying to code a macro which will basically look through a list of values. What it will do is go through each entry of the S column (starting from S2), see if that entry is less than30 and if it is will copy the entire entry (A2:AH2) to another worksheet. I have written some code but I am getting the object required error and I have some questions

1) how do I perform operations one two declared variables ranges. For example the way I use it in my code is as follows but I get am error (object required)

Please Login or Register  to view this content.

2) I am using a for loop and I want the declared ranges to be offset by one row when the loop runs again. Again I am getting an error for this and the code I am using is..

Please Login or Register  to view this content.

Any kind of help would be appreciated Here is the whole code below if you guys want to have a look

Please Login or Register  to view this content.

[Mordred]

Hi someone and welcome to the forum. Please take a moment to read the forum rules located here and amend your title as per Rule #1. Also, you need to wrap all code in code tags as per Rule #3. Once you do that, someone will be able to help you.

Regards