I imported around 800 products , all the fields were correctly imported apart from sku , as sku is nvchar , so it should accept numbers or string or combination of both , but only the sku starting as a number is imported for instance 199 is added while C199 is not added similarly 201C is added but BP104 is not added, any ideas
Sub Add_Apostrophe() Dim rng As Range Set rng = Range("K2:K" & Range("K65536").End(xlUp).Row) For Each cell In rng cell.Select If cell.Value <> "" Then cell.Value = "'" & cell.Value End If Next End Sub
Macro 2 for MPN
Sub Add_Apostrophe() Dim rng As Range Set rng = Range("L2:L" & Range("L65536").End(xlUp).Row) For Each cell In rng cell.Select If cell.Value <> "" Then cell.Value = "'" & cell.Value End If Next End Sub
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.