Thanks Ron......That is simple....I learn something new everytime I read this
forumn. Hope this helps the original op out.

Don

"Ron Rosenfeld" wrote:

On Sat, 1 Mar 2008 17:43:01 -0800, Don wrote:

However, this is case sensitive and I've played with it for some time and
can't get it to be case insensitive,

Simple way to make the comparison case insensitive is to precede your macro
with

Option Compare Text


So the start of your macro would look like:

Option Compare Text
Option Explicit
Sub Macro4()

Dim LastRow As Integer
Dim i As Integer
Dim x As String
Dim Col As String
--ron