copy rows based on several conditions

[benweizm]

hi
I'm very VBA beginner
I would glad to get your help

I need write vba program which runs on sheet with fixed columns.
where it is not known how many records have been added (so it cant get a number rows as constant parameter)
this program check for every record if it meets the conditions - for example:
the value in column A is bigger than 4 but smaller than 17
the date in column B falls between last week.
....and more
finally this program select the relevant rows from column A to U


thanks u so much!!!!!

Ben

[frabulator]

It sounds like you would like to look into if statements.

However, if what you are wanting to do is something as simple as checking to see if something falls within a range you might not need to use vba. Check out this Microsoft page on how to use if statements inside of an Excel cell.

[benweizm]

thanks for your reply
but my problem is not "if" statement.
my problems are:
1. how the program can pass along all cells in the range which his end can be changed
2. how can the program select rows selectively
3. how can expand this selection to several columns of the relevant rows.
4. how can I compare between dates

thanks.