I have list of invoices amount for several currencies I want macro to check all amounts and convert it to $ by using rate from assumption box in the sheet
I suggest you post a sample workbook that accurately reflects your real data layout. There is not enough information currently to write accurate code for what you want.