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.

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.