Search results for query: *

A simple issue that I'm stuck on -- recording a macro -- select column A followed by doing a replace function. When the macro is ran the entire sheet is selected and any occurrence is changed in all columns. Columns("A:A").Select Selection.Replace What:="N", Replacement:="NOT FOUND"...

Skip, Thanks for the tip -- I will look into Conditional Formatting for this task. Again, I thank you for your help -- you've got me going in the right direction. BigNorton

Skip, Thanks for the direction -- I'll do some looking at the property so that I can understand where I went wrong. I appricate your help and input. Your question as to why the mixing of numbers and text in the same column -- I need the value of zero to really stand-out from any of the...

Skip, The problem is that I'd like to look at the number as a whole -- only change a zero value to UK. So, in my example the results would be -- Value Results 0 UK 10 10 107 107 1.02 1.02 Sorry if I wasn't clear.

I'm really new to VBA and have a question about Selection.Replace on a cell with numeric values. The quest -- change cells with value '0' to 'UK'. Examples of cell values -- 0; 10; 102; 14, etc. With the following code the each '0' in the value changes to 'UK', so in my examples you get UK...