scott wrote:
>> And this stuff isn't really documented anywhere.
> 
> Rubbish!
> 
> Try looking up "range" or "cells" or "worksheet" in the object browser 
> and reading the help.

What is the "object browser"?

> Worksheets(1).Cells(1, 1).Value = 24
> 
> ActiveSheet.Cells(2, 1).Formula = "=Sum(B1:B5)"
> 
> How could it be any more clear what to do?

That seems reasonably clear.

Now, if you call a macro with a cell range as its argument, how does 
that work?

> Or, as Gilles said, record a 
> macro and then look at the code (and the help related to the code 
> generated) - a nice trick for learning how to do lots of things in Excel 
> (like creating charts, changing borders, sorting etc).

I'm still at the level of not really knowing how to work the VB editor, 
and not understanding basic VB syntax constructs...

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message