Correction of the Macro in which we can put formula

[zyxw1234]

Plz see the vba macro from the below link
https://drive.google.com/open?id=11FAIt ... 7uSJ5dzXgS

[HansV]

You have some quoted strings such as "BUY" in the formula. This formula itself is a quoted string. That causes confusion. To solve this, double the quotes for strings inside the formula. So for example, "BUY" becomes ""BUY""

[HansV]

By the way, you can include code in your posts. Enclose it in [code] and [/code] tags. For example, your macro on Google Docs is:

Code: Select all

Sub test()
  Dim Wb1 As Workbook, WS1 As Worksheet, Lr1 As Long
  Set Wb1 = Workbooks.Open("C:\Users\Desktop\TEST.xlsx")
  Set WS1 = Wb1.Worksheets.Item(1)
  Let Lr1 = WS1.Range("H" & WS1.Rows.Count).End(xlUp).Row
   WS1.Range("J2:J" & Lr1 & "").Value = "=IF(D2<H2,"BUY",IF(D2>H2,"SHORT","Delete"))"
   WS1.Range("J2:J" & Lr1 & "").Value = WS1.Range("J2:J" & Lr1 & "").Value
   
   Wb1.Save
   Wb1.Close
End Sub

[zyxw1234]

Thnx Alot HansV Sir for helping me in solving this problem
Problem Solved
I tried to put the code in the post but i am getting error in pasting the code in this forum(/) this is been removed automatically

[Leif]

I tried to put the code in the post but i am getting error in pasting the code in this forum(/) this is been removed automatically

Where are you copying it from?

[HansV]

If you copy code from the visual Basic Editor into a post, you shouldn't have problems.

[zyxw1234]

From excel, its not this website fault, I think my system fault