Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GET PAID FOR INCOMMING!!!!-FREE VIRGIN CONNECTION!!! | Excel Worksheet Functions | |||
GET PAID FOR INCOMMING!!!!-FREE VIRGIN CONNECTION!!! | Excel Discussion (Misc queries) | |||
I am a virgin to Excel | New Users to Excel | |||
Q: Creating a macro to sort and group columns in a sheet according to another sheet | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |