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

 

[Joe4]

Try changing:

[COLOR=#333333]"=(R[1]C[-13])"[/COLOR]

which offsets the row count by 1 to:

[COLOR=#333333]"=(RC[-13])"[/COLOR]

Note you can also speed up your code and shorten by getting rid of most your Select statements. They are not neceesary.
This:

[COLOR=#333333]Range("AA6").Select[/COLOR]
[COLOR=#333333]ActiveCell.FormulaR1C1 = "=(RC[-13])"[/COLOR]

can be simplified to this:

[COLOR=#333333]Range("AA6").[/COLOR][COLOR=#333333]FormulaR1C1 = "=(RC[-13])"[/COLOR]

And this:

[COLOR=#333333]Range("AA6").Select[/COLOR]
[COLOR=#333333]Selection.Copy[/COLOR]

can be simplified to:

[COLOR=#333333]Range("AA6").[/COLOR][COLOR=#333333]Copy[/COLOR]

etc, etc

 

[Fluff]

How about

Sub w3202L()
Sheets("Misc").Select
Range("AA6:AA370").FormulaR1C1 = "=(RC[-13])"
Range("AA11").Select
End Sub

I'm definitely getting slow today

 

[deanl33069]

TY Everyone this is working well......I did 4 different formulas from the statement.
How can i create pull down menu to select different ones?

 

[Joe4]

How can i create pull down menu to select different ones?

I do not know what you mean. Please explain in more detail.

 

[deanl33069]

so i have used 4 different scripts i would like to make a drop down menu to select which script to use....tyvm
1)Sub w3202L()xxxxxxxx
2)Sub w3201L()xxxxxxxx
3)Sub w3102L()xxxxxxxx
4)Sub w3101L()xxxxxxxx
I

 

[Fluff]

Is your dropdown a Data Validation dropdown?
If so what cell is it in?

 

[deanl33069]

No
these are inside a module 9 , I want to create a drop down menu using thes 4 different formulas

 

[Fluff]

I'm afraid I don't understand, where is your dropdown menu & what type of drop down is it?

 

[deanl33069]

I have not created oned yet I want to know the best way to do this .....ty