VBA - convert Imperial Size to Metric Size

Hi Experts,

Need VBA help to for a repetitive task in excel;

I have the following spread sheet.
1. cs-asmemetric1.xls that contains my catalog values
2. NomDiaMap.csv that contains imperial-metrics sizes lookup table

Steps for each worksheet:
1. Copy all imperial size in column B (starts from B3 to last value)
2. Paste copied imperial size to row 3 of column with name "mmSize". Column "mmSize" is not fix position. If possible add a condition: do not paste if row 3 of column "mmSize" is not blank/empty
3. Replace/Convert imperial size in column "mmSize" to metric size as per lookup table NomDiaMap.csv
4. Column "mmSize" shall be number stored as text only

Process options: (user can run either active sheet only or the whole workbook)
1. active worksheets
2. all worksheets except worksheet "Catalog Data"

Thank you in advance.

NomSize_Imp2Metric.jpg

Need help to solve run-time error '91': and possible improvements

The macro seems working if it is within the workbook but when I copied the exact code to Personal.xls, It run-error '91' when I run the macro.

attached excel file with macro.

error.jpg

Thank you in advance.

surely a simple Vlookup would do what you wish, it would be easier with the csv file as a tab in the excel document

Vlookup(inches value, the csvfileA:b,2,false)

@davsth

The file cs-asmemetric1.xls is only a temporary export file from another application, once the changes finish, it will be imported to back.
If this is a permanent file i will consider using vlookup.

The macro inside the file was working fine. It only returns an error when I transfer the macro to personal.xlsb