I am need of some code assistance. I am new to VB and still learning. The code I am looking for help on is as follows:
- Would like to select a column on one sheet that is filled with numeric values and replace any valve that is greater than a specific value with another.
-The number of instances within the column is unknown and the length of the column varies.
-The value to "judge" by is located on another sheet in the same workbook. It is a single cell entry. This "judge" value is also the same value to replace the cells in the column with.
In other words, if any cell in a column is greater than x, then replace it with value x. If it is less than x, do nothing. X is a user enter value on another sheet within the same workbook.
Any help would be appreciated. Remember I am a newbie to this.
MR
- Would like to select a column on one sheet that is filled with numeric values and replace any valve that is greater than a specific value with another.
-The number of instances within the column is unknown and the length of the column varies.
-The value to "judge" by is located on another sheet in the same workbook. It is a single cell entry. This "judge" value is also the same value to replace the cells in the column with.
In other words, if any cell in a column is greater than x, then replace it with value x. If it is less than x, do nothing. X is a user enter value on another sheet within the same workbook.
Any help would be appreciated. Remember I am a newbie to this.
MR