Hi all,
I have a macro which inputs currency and decimals into the same cells. the problem is that every time i run the macro whichever type (currency/decimal) is inputed first remains as the cell format. For example if i run the macro for the first time and currency values is entered into the cells, then run it again and decimals numbers is inputted into the same cells, the decimals would look like currency. how can i change this and get the cells to represent the inputed values as they are really meant to be. Here is a piece of the code. the problem is where var1min/max and var2min/max is inputed into cells 26 to 29 column A and B.
'Input the minimum of the two variables'
Bookmarks