Mac office 2016 Excel VBA Copy Paste code error

Question

Hi

I've created a VBA code on Windows for compile a data and remove the blank cells by filtering data, and then copying the cells with values and pasting over to another area of the same sheet. All the references are on the same sheet/workbook but it copies and pasts two columns at a time and pasting both instead of only one at a time.

Below is the code where error is occurring. Also on the next step it doesn't go to the Print Preview stage somehow.

Sub Print_Estimate()

'

' Print_Estimate Macro

'

'

Range("Q14:Q31").Select

Selection.Copy

Range("D77").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=True, Transpose:=False

Application.CutCopyMode = False

Range("R14:R31").Select

Selection.Copy

Range("K77").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=True, Transpose:=False

Application.CutCopyMode = False

Range("B54:L130").Select

ActiveSheet.PageSetup.PrintArea = "B54:L130"

ActiveWindow.SelectedSheets.PrintPreview

Range("C12").Select

End Sub

Answer 1

For windows : http://www.rondebruin.nl/win/s5/pdf.htm

For Mac : http://www.rondebruin.nl/mac/mac005.htm

Answer 2

Hi Lizzie,

You've given us the code, but not the worksheet on which the code is designed to run.

If you can remove confidential and personal information first and then share the workbook, we can try your code on the worksheet you have and see how it goes. You can share your workbook on OneDrive, DropBox or other sharing service and then reply with the link.

It would also be helpful if you include the version and build number of Excel that you're using. You can find that information in the Excel menu by choosing About Excel.

Thanks.

Answer 3

You do, but that forum is like 99% for Windows, not Mac.

THIS is the correct forum for Mac issues.

Answer 4

Thank you very much. Appreciated.

Answer 5

Hi,

We have another forum where Microsoft experts and software developers can further assist you. To go to this forum, see this link.

Regards.