left makes the result text - try adding a zero to make the result of left a number =Left(a1,6)+0
Not sure if i have understood correctly (always best to add an example), but would the below work? =IF(ISNUMBER(MATCH(G5,$X$6:$X$13,0))=TRUE,WORKDA...
Can you add an example workbook?
i would use match, but i assume you will need to do a 2 way match =MATCH(TRIM(A2),TRIM(C:C),0)
Not VBA but have you looked at getting emails in Power Query? you can connect directly to Microsoft Exchange and then just refresh - i know nothing...
Please add a workbook example to see what we are looking at Personally i dont use FileSystemObject when checking if folders exist, i find it much e...
Please add a worksheet rahter than a picture otherwise we have to waste time recrating data that already exists Do you want 5 to not have a colour?...
i assume at some point the data was in a csv file? i would check how the file is being imported and see if it is being converted due to the comma ...
nothing attached
wsLR = ws.Cells(Rows.Count,1).End(x1Up).Row Firstly it looks like you have a 1 in the xlup part instead of an L Secondly this is counting the ro...
Can you add the macro in a work book and some test data so we dont have to recreate?
Please add an example work book so we can see the code on context
Please add an example workbook and not a picture, that way we can see your code and adjust
Copy and paste? (sheet1) Embed as an object?(sheet2) Depends what you want to do with it
The black dimond question mark is unichar 65533 <=UNICODE(a8)>, once you have that you can run something like Sub CLEARRUBBISH() Cells.Rep...