Posted by Herman on July 31, 2001 3:40 AM
I like to know how i can do the following
i have a workbook with 3 sheets
each sheet has in different cells,cells with a currency in it.
i want that my macro looks in all 3 sheets
and look for cells with currency and then multiply the cells found with 1.2
because some sheets have only 3 rows data i also want
that before the macro starts, the macro looks for the last cell and only loops for searching for currency cells in for example the range a1:c7 (where c7 is my last cell)so my macro finishes faster