Excel VB Help

[nighthawk-uk]

Hi All,

I am looking for some help with a vb script i am writting for work, i have looked through all of my books & cannot find what i presume to be a simple line of code. Hopefully someone here will have come accross the same issue & had better luck than me.

i am trying to get a macro to go down to the next "available line" line.

ie i am filtering a selection using the autofilter & then want the macro to select the next available line not filtered out.

Every time i have tried to do this by recording the macro, it is selecting a cell reference (ie "C2"). The closed command i can fine is

Range(Selection, Selection.End(xlDown)).Select

This effectivly holds down the ctrl key & presses the down arrow. what i want to do is the same thing without pressing the ctrl key.

i hope i have explained this clearly.

thanks,

Steve