Hello,
I'm trying to execute the VBA code below but I get a run-time error 13 Type Mismatch with a highlight on If cell.Value <> "" Then.
I cannot manage to figure out what is missing or incorrect here. Would someone help or point me to the right direction to solve this please?
Thank you.
Please Login or Register to view this content.
Can't replicate the issue - maybe share a sample workbook?
If you think that it's the If cell.Value <> "" Then line that's causing the issue, try replacing with If Not IsEmpty(cell) Then
<<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts
ah, could be that you've declared 'cell' without a type. Best practice is to use a term that isn't likely to be misinterpreted, e.g. 'MyCell'
Then try Dim MyCell as Range etc....
Hello. Try with:
PHP Code:Sub Update_Remit_Column()
Application.EnableEvents = False
With Sheets("Sales")
.Range("V2:V5000") = .Evaluate("IF(AG2:AG5000<>"""", ""Yes"", V2:V5000)")
End With
Application.EnableEvents = True
End Sub
You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.
Thank you very much for your contribution. They helped me learned more things about coding. beyond Excel's suggestion resolved my issue and made it even easier. Thank you.
That's good!...I'm glad it's like that and thanks for the +Rep.Originally Posted by rakotonirinas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks