Basic Last row query

Hi i need a formula to

Select A1:K1 & Lastrow

Please Login or Register  to view this content.

I have tried the above but it doesnt work it selects a1:k1 but then selects all the cells down to end of the excel document where as the data in cell a ends at row 500 (this can very depending on which sheets i am using).. any help .. ? my vb knowledge is basic but improving


would this work better ? Range("A1").CurrentRegion.Select

Use


Range("A1:K" & Lastrow).Select

thanks for the help once again

Please Login or Register  to view this content.

Can i do 2 advanced filters

Ie ADVANCED FILTER filters the data then I want to filter it futher agaoin.

I have the above code but Range("I1:I300").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"U1000:U1007"), Unique:=True always resets the first filter and then displays the results

for example coloum I shows : john , peter , ian, dev , mark
after filter one it shows john , peter only
I need these unique names , but when filter 2 takes place it displays john , peter , ian, dev , mark
instead of john , peter only

I hope this makes sense, I pray there is an easy fix