I have a macro that will add a formula to a cell and copy it down the column based on several different variables that have all worked great until I get to the formula. I am not sure what is causing it to go wrong. If anyone could help me figure out how to include the LCVPR1 in the formula, that would be great. Maybe I should switch to using relative references?
Last edited by jonathanramey; 04-08-2024 at 12:48 PM.
Try changing FormulaArrayR1C1 to FormulaArray.
Artik
That did not work. Could I have missed something somewhere else? I did try some other things such as having it input a much simpler formula and using Range(LCVPR1 + 1 & "2") instead of Cells and that did not work, which is why I switched, but maybe I am not doing that right? I also have not done a "Dim LCVPR1 As ___" statement, which I am still learning, so maybe that has something to do with it as well? The following line does work, so I am really just unsure as I am still fairly new to VBA.
Sheets("Vendor Pricing Rules").Cells(1, LCVPR1 + 1) = txtVendorCode
Maybe
LCVPR1 = Cells(1, Sheets("Vendor Pricing Rules").Range("J1").End(xlToRight).Column + 1).Address
Cells(2, LCVPR1 + 1).FormulaArray = "=IF('Input Values'!$L2=" & LCVPR1 & ", IF('Input Values'!$J2="""", """", IF('Input Values'!$P2="""", """", 'Input Values'!$P2)), """")"
This didn't quite work, but I did try adding the +1 to the original "LCVPR1 =" line instead of using it in the formula itself as you did and that made it work. Thank you very much for your help!
Glad to have contributed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks