I have a workbook with multiply sheets with various data that contain currency, percentages and text, because this project need to function in two different languishes , the currency format need to be adjusted according to the country it used . therefore I am looking for a VBA code that can identify two things ,
1. If the sheet is HorizontalAlignment = xlLeft (i.e left to right ) currency’s symbol should be $ or € and if the sheet is HorizontalAlignment = xlright (i.e right to left ) currency’s symbol should be ₪
2. In the place where is % and/or text formatting do nothing ,

Thank you for your assistance