|i'm busy at the moment and dont have the time to write the code, guess you should try to make it works. |
yeah, the code works as what i intend it to, if cell value at F5 is number and bigger than 0, then copy used range from "A5:F5-downwards" to new sheet.
so you want to evaluate every cell at column "F", then here is a hint:
for each c (cell) in range at column 5
if c.value is bigger than 0 then
do identify the row range of this cell and copy the row to new sheet
search builtin-help (F1) for cell, column, row, and range and looks for available properties and methods that you use.