a macro...for a virgin sheet
Hello all,
I have one workbook with only 2 sheets
Sheet1 <empty*virgin*
Sheet2 <i have data as follows
A1:A7 = 100,200,300,400,500,600,700
the above represents the rows i want to select on Sheet1
based on the above data, i want to filter the Rows on Sheet1...because i
will paste array formulas on the selected rows
The number of rows on sheet2 and the filtered Row(#'s) on sheet1 may vary...
I want to run the code only and only if the sheet1 is *virgin*. Otherwise
"Abort it!"...
i hope i can just record it myself!
thanks and really appreciate your guidance...
regards,
driller
--
*****
birds of the same feather flock together..birdwise, it''s more worth
knowing the edges rather than focusing in one line! Know the limits and
remember the extents - dive with Jonathan Seagull
|