Selection.Copy line not working on Mac

[Mustang0710]

I have a large macro that creates reference columns based on other data in the workbook. This macro is working fine on a Windows PC, but is giving me issues on the Mac version of Excel.

Section of code:
Range("O2").Select 'Enter formula on first cell
Cells(2, 15) = "=IF(ISERROR(VLOOKUP($B2,$S$2:$S$50000,1,FALSE)),"""",""Yes"")"
Range("O2:O" & NLastRow).Select
Selection.FillDown 'Copy down through all nodes
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False 'Debug MAC
Application.CutCopyMode = False

The Selection.Copy command does not appear to do anything, so when it tries the Selection.PasteSpecial line, it receives and error because nothing has been copied.

Thank you very much for your help.

 

[mikerickson]

Try

With Range("O2:O" & NLastRow)
    .FormulaR1C1 = "=IF(ISERROR(VLOOKUP(RC2,R2C19:R50000C19,1,FALSE)),"""",""Yes"")"
    .Value = .Value
End With

 

[Mustang0710]

Thank you...thank you

That works great and accomplishes the same function. Now I just need to find all the places where I use FillDown, Copy and PasteSpecial to replace the code.
I appreciate the quick response

This site is fantastic!

 

[mikerickson]

It wasn't the use of FillDown, but the use of Selection.

 

[Mustang0710]

So how do I copy a range on the Mac? Will this work as well?

Range("O2:O" & NLastRow).Copy

 

[mikerickson]

Since you were using PasteValues, you don't need to Copy. You need to make the values of the target range the same as the values of the source range.

code like

Range("G2:J5").Value = Range("A1:D4").Value

is much faster, and less prone to crashing, than

Range("A1:D4").Copy destination:=Range("G2:J5")

And, I can't replicate the error you mention in the OP, the OP code works fine for me on my Mac (Excel 2011)

 

[Mustang0710]

All for making it the most efficient.

Yeah, I have a few hundred PC users using these macros and less than a dozen on Mac. However, I noticed that the Mac users (different Mac OS or Excel version) get different errors. I was able to fix some and I hope this will fix the remaining ones.

Thank again for all your help!!!