Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select rows
i imported a address list into excel. i want to set it up as a data
base. the list had no headers and consists of 2500 names & addresses. if i can select every 6th row i can accomplish this rather quickly. is there a way do this rather than by contrl clicking each row. the list is three colums wide. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select rows
if I understood corretly try this
click view(menu bar)-toobars-form in the form controlbox click any button e..g check box cand draw it somethere conveniently in standard module type this Public Sub test() Range(ActiveCell.Offset(6#), ActiveCell.Offset(6, 3)).Select End Sub right click the checkbox and clcik assing macro in the assigns macro window choose test now select A1 now every time you click checkbox the cursor will go to sixth row three column wide experiment on this you can start anywhere A1 or A2 etc. is this what you want. wrote in message ups.com... i imported a address list into excel. i want to set it up as a data base. the list had no headers and consists of 2500 names & addresses. if i can select every 6th row i can accomplish this rather quickly. is there a way do this rather than by contrl clicking each row. the list is three colums wide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I invoke running a macro from within an "IF" function. | Excel Worksheet Functions | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
How to select and deselect rows in Excel | Excel Discussion (Misc queries) | |||
How to select and deselect rows in Excel | Excel Discussion (Misc queries) | |||
How do I select multiple rows randomly in MS Excel? | Excel Discussion (Misc queries) |