[RESOLVED] Writing to cell error

[stimbo]

You know, that will do just fine. Actually more than fine. Thanks!

Just out of curiosty, is the line I posted simply wrong and that's why it doesn't work or should it work?? Doesn't matter if you aren't sure, I'm just wondering.

[annix]

Fantastic

I'm no expert, but I've not seen

cell(100, 1).Value

used before.

I tend to record a Macro if I'm unsure how to do something (EG if I want to replace the contents of a cell, I'll run a macro and manually do that; then look at the code and do it that way in the future).

As I said though, I'm far from an expert, so you may have been close doing it that way!