johnmerlino
Registered User.
- Local time
- Today, 05:44
- Joined
- Oct 14, 2010
- Messages
- 81
Hey all,
I have this macro below:
It's supposed to search the length of column A, however long or short it may be, and extract cells which contain a comma into column b. If the cell in column a doesn't contain comma, then it just leaves the corresponding b cell empty.
The macro above, however, doesn't pull any cells in column b, despite there being cells with commas in column a.
Thanks for response.
I have this macro below:
Code:
Sub extract_deeds()
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
Range("B1:B" & LR).FormulaR1C1 = _
"=IF(ISNUMBER(FIND("","", A2)),A2,"""")"
Range("B1:B" & LR).Copy
Range("B1").PasteSpecial xlPasteValues
End Sub
The macro above, however, doesn't pull any cells in column b, despite there being cells with commas in column a.
Thanks for response.