How to input a sub result into a range

Hi all

I am trying to automate the process of importing and sorting data from an application.

Ive been trying to use a macro in which an advanced filter, filters the data by organisation and this data is then copied to a different worksheet. My problem exists however in that the macro i recorded has a range of 287 rows so if the next month 500 rows are imported, only 287 rows will get filtered.

I found a sub that will find the number of rows and the result of this is a variable called lastrow.

Is there any way that i can assign this value to the range used within the advanced filter.

eg

lastrow = 500

Range("A1:I287) need to get 500 in where 287 is

Is there any way of doin this?

If my explanation doesnt make sense please ask for clarification as i will be online for most of the day.

Many many thanks in advance

I just saw a post by Carim helping someone with a similar prob to use

Please Login or Register  to view this content.

However it doesn't work and i think its because of the advanced filter straight after??

Please Login or Register  to view this content.

Any Ideas?

Thanks