View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Changing Cells, How to

Not sure on this one. Is the sheet or the cell protected?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mac Lingo" wrote in message
nk.net...
Bob,
This is the line of code that does the write
Worksheets("Sheet3").Cells(4, 4).Value = "String"

When I execute this line, the values in the "Quick Watch" area goes "out

of
context".
This code is called from the ActiveWorkSheet and I need to update another
cell on the same line.
I have figured out how to get the line number, but still can't do the

write.

Thanks again for your help.

Capt Mac
Ocean Rider (Pacific right now, but am looking forward to the British

Isles
one of these days)