Hello. I am new here. I have run into a problem with a macro and I don'
have much hair left to pull out. I have a macro that resets defaul
values to cells on several sheets of my workbook. This works fin
except for a few values and I can't see a pattern other than the onl
fields that I am having a problem with are ones I'm trying to set t
"TRUE". The code looks like this:

Worksheets("RBRQ1").Range("B8:B9").ClearContents
Worksheets("RBRQ1").Range("B12").ClearContents
Worksheets("RBRQ1").Range("B10").Value = 1
Worksheets("RBRQ2").Range("D34").Value = "TRUE"
Worksheets("RBRQ3").Range("D34").Value = "FALSE"
Worksheets("RBRQ4").Range("B8:B10").ClearContents
Worksheets("RBRQ4").Range("D34").Value = "FALSE"
Worksheets("RBRQ5").Range("I9:I10").ClearContents
Worksheets("RBRQ5").Range("D34").Value = "TRUE"
Worksheets("RBRQ6").Range("D34").Value = "TRUE"
Worksheets("RBRQ6").Range("D35").Value = "FALSE"
Worksheets("RBRQ6").Range("D36").Value = "FALSE"
Worksheets("RBRQ6").Range("E34").Value = "FALSE"
Worksheets("RBRQ7").Range("D34").Value = "TRUE"
Worksheets("RBRQ7").Range("D35").Value = "FALSE"
Worksheets("RBRQ7").Range("D36").Value = "FALSE"
Worksheets("RBRQ7").Range("D37").Value = "FALSE"
Worksheets("RBRQ7").Range("E34").Value = "FALSE"

The lines in red are the only ones that don't get set. I ran the debu
on this subroutine and at each of these three lines, it would jump t
that sheets macros and execute the code found first??? (Strangel
enough, this code found should set the values to what I want, but i
doesn't seem to set them.)

I have run this under Excel 2003 and Excel 2000 and the results are th
same. Any help would be appreciated

--
Bruce00
-----------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...fo&userid=2663
View this thread: http://www.excelforum.com/showthread.php?threadid=39904