Hello,
I am trying to create a macro to select E2, then run a formula within an autofill based off of column A.
Sub Formula()
'Assign a flexible formula to a range of cells
For x = 2 To 1000
If range("A" & x).Value = Then range("E" & x).Formula2R1C1 = right(D2,5)
End Sub
My error is "then"
This would be the right syntax:You need to say to what "Range("A" & x).Value" is equal to and note the double-quotes arround the formula.
Please Login or Register to view this content.
Hello,
thank you for a quick response, I have updated my macro but now receive an error message of "without next"
That's right and that's why they call the loop a For/Next; so this is how your macro should be:Then you will need to valorize the variable what telling VBE it's content, I mean, what should contents of Range("A" & x).Value be equal to ?Please Login or Register to view this content.
By the way, why are you using .Formula2R1C1 instead of .FormulaR1C1 ?
You should also add as first line of your panel Option Explicit. It will help with debugging and avoid/indicate some other errors.
Last edited by rollis13; 11-17-2022 at 05:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks