VBA Macro to select area not working

[Browneh89]

Hello all!

I'm having a little trouble with a macro I am attempting to record. The macro is supposed to filter a table of data (removing all blanks rows) then select an area in prep to print. when I record the macro I use Ctrl + Shift + arrow key to select the area which I have used before to write a similar macro (which works perfectly) however this time it won't select past the coloums which filter the data. Does anyone know what could be causing this?

Example of the macro that's failing below;

Sub Macro4()
'
' Macro4 Macro
'

'
ActiveSheet.Range("$B$4:$V$99").AutoFilter Field:=5, Criteria1:="<>"
Range("O1").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
End Sub

Thank you in advance for any help you can offer!

 

[JLGWhiz]

Thank you mate this worked perfectly!! Do you know why my original macro did not work?

IIt is the way Excel is designed to work. While it looks like you are doing the same thing you did in another file, the content of the sheet in in this file is most likely different and you are getting a different result. That is why it is better to use direct coding as opposed to the Select and Activate method.