Hi,

I want to use a macro in a worksheet. In the worksheet, I have to select
only some columns, not all. Now, the number of rows are also refreshed daily
in that sheet.
I have to apply conditions also in that macro for selecting the particular
rows.
Can I use if statement in the VB editor, and what command should i use with
if to select a particular cell?
Activecell?

For example, I have to select column 3, 8 and 10 and check for all rows
which have a value in column 5 equal to 0. Then I have to copy these rows in
another sheet.

Please help me out.

Thanks in advance.