Does

Range("H2").value = 456
and
range("h2").value = ""

work ok?

(Are those cells unlocked? Format|cells|Protection tab to check.)

And I'd visit google to search the archives of the newsgroups.
http://groups.google.com/advanced_group_search

john wrote:

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/

--

Dave Peterson