Quick VBA question.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Syntax below work<o></o>
Method 1
<o> </o>
Tried changing it to <o></o>
<o> Method 2</o>
<o> </o>
I get Error 2029.<o></o>
<o> </o>
I am trying to remove range and use [] to make code shorter.<o></o>
What code modification must I make to make Method 2 work with square brackets []?
Biz
<o> </o>
Syntax below work<o></o>
Method 1
Code:
With Range("L2:L" & LR)<o:p></o:p>
.Formula = "=LEFT(M2,SEARCH(""_"",M2)-1)"<o:p></o:p>
.Value = .Value<o:p></o:p>
End With<o:p></o:p>
Tried changing it to <o></o>
<o> Method 2</o>
Code:
With [L2:L & LR]<o:p></o:p>
.Formula = "=LEFT(M2,SEARCH(""_"",M2)-1)"<o:p></o:p>
.Value = .Value<o:p></o:p>
End With<o:p></o:p>
I get Error 2029.<o></o>
<o> </o>
I am trying to remove range and use [] to make code shorter.<o></o>
What code modification must I make to make Method 2 work with square brackets []?
Biz