2004 macro won't run on 2011

[philcarling]

Hi

I'm new to this forum. I have a macro that works perfectly on excel for Mac 2004 but has errors on 2011.

This bit of code fails and the debugger highlights the line I've marked with an @ symbol :-

The error message prior to clicking the debug button is :-

Run time Error '1004'

A Range is required.Select at least one cell within arange and try again.

Any help would be much appreciated


Sub phoneordernoVAT()
'
' phoneordernoVAT Macro
' copies no VAT rows from sheet: phoneorderall and pastes into sheet: phoneordernoVAT
'

'
Sheets("phoneorderall").Select
Selection.AutoFilter @
Selection.AutoFilter Field:=6
Selection.AutoFilter Field:=6, Criteria1:="=0", Operator:=xlAnd
Cells.Select
Selection.Copy
Sheets.Add
Sheets("Sheet9").Name = "phoneordernoVAT"
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

[Marc L]

Hi !

According to forum rules, edit your post and use code tags ‼

And here is the PC forum, you should move to the Mac forum …

[techflutter]

You will have to leave the excel file as a .xls when opening it with office 2010. There are subtle differences between the vba code between office 2003 and 2010.

I have had the same problem when i converted my .xls files to .xlsm and tried to run them in 2010 they did not work. When i left them as .xls they were fine!

James

[Marc L]

I still use 2003 version and at least 95% of my codes work on later versions …

[techflutter]

what is the extension of the file that you are having the issue with?

[philcarling]

Thanks for the replies !

I've tried leaving the file ext's as xls and also tried saving them as 2011 docs.

Marc L can you let me know what you mean by post tags ?

[Marc L]

Use # icon …

[philcarling]

Ok thanks

Is that ok now below ?

Should I create a new thread on the Mac forum ?

Please Login or Register  to view this content.

[philcarling]

Have to go out now for the evening so if anone replies I'll respond tomorrow