Formula check

[deanl33069]

I have this formula

Sub w3202L()
'
' w3202L Macro
'


'
Sheets("Misc").Select
Range("AA6").Select
ActiveCell.FormulaR1C1 = "=(R[1]C[-13])"
Range("AA6").Select
Selection.Copy
Range("AA6:AA370").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("AA11").Select
End Sub

I need AA6 to be N6 and it comes out N7

 

[Fluff]

Have a look at Data Validation https://www.excel-easy.com/examples/drop-down-list.html