# Thread: Formula check Thanks:  2 Post #5330222 (1)Post #5330224 (1) Likes:  2 Post #5330224 (1)Post #5330222 (1)

1. ## Formula check

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

2. ## Re: Formula check

Try changing:
Code:
`"=(R[1]C[-13])"`
which offsets the row count by 1 to:
Code:
`"=(RC[-13])"`

Note you can also speed up your code and shorten by getting rid of most your Select statements. They are not neceesary.
This:
Code:
```Range("AA6").Select
ActiveCell.FormulaR1C1 = "=(RC[-13])"```
can be simplified to this:
Code:
`Range("AA6").FormulaR1C1 = "=(RC[-13])"`

And this:
Code:
```Range("AA6").Select
Selection.Copy```
can be simplified to:
Code:
`Range("AA6").Copy`
etc, etc

3. ## Re: Formula check

Code:
```Sub w3202L()
Sheets("Misc").Select
Range("AA6:AA370").FormulaR1C1 = "=(RC[-13])"
Range("AA11").Select
End Sub```
I'm definitely getting slow today

4. ## Re: Formula check

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?

5. ## Re: Formula check

How can i create pull down menu to select different ones?
I do not know what you mean. Please explain in more detail.

6. ## Re: Formula check

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

7. ## Re: Formula check

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

8. ## Re: Formula check

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

9. ## Re: Formula check

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

10. ## Re: Formula check

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