I worked it out 
Using named ranges in the first column of the header row made it simpler for me.
Sub Report_Micrometer_Interchange()
' Report_Micrometer_Interchange Macro
Sheets("Report-Micrometer (Interchange)").Select
Dim x As Integer
x = Range("Placement_X")
Range("Report_IM_MZero").Offset(-1, 0).Select
Selection.Cut
Range("B" & MicrometerZero).Offset(-1, 0).Select
ActiveSheet.Paste
ActiveSheet.PivotTables("Pivot_IM_MZero").TableRange1.Cut
Range("B" & MicrometerZero).Select
ActiveSheet.Paste
End Sub
Thanks
Bookmarks