Macro not needed - the Advanced filter functionality can handle it.
Say your list has the heading Numbers.
In some unused area of the spreadsheet, enter these values in 2 rows and 2
columns
Numbers Numbers
599999 <699999

Select the Numbers list and click Data, Filter, Advanced Filter
Select Copy to another location,
the List range should be populated with the address of the Numbers list,
for Criteria Range enter the range where you entered the above 4 values,
for Copy To enter the address of a cell where you want the filtered list to
begin.
--
TedMi

"Kasper" wrote:

Hi

I need to write a macro that selects numers in a coloumn that are
higher than e.g. 5999999 but lower than 6999999 and copy them. Any
ideas?

The numbers are sorted according to value, so the lowest number is
first and the highest number is last in the coloumn.

Any help will be appreciated.

//Kasper