I have a spreadsheet that is protected and mostly locked. I do not have a
password. There is a merged range, I2:H2, where a user can manually input
data. When I record a macro I get code like this:

Range("H2:I2").Select
ActiveCell.FormulaR1C1 = "456"

or

Range("H2:I2").Select
Selection.ClearContents

When I attempt to include this code in my VBA macro I get "Select method
of Range class failed".

So far nothing else I've tried works either. I can neither read nor write
to the merged area from code. Is there anything I can do?

John

P.S. Anyone know how can I search all newsgroup message text using Opera?
The quickfind only appears to search the message title.

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/