try something like

ActiveCell.Offset(iOffsetRows, iOffsetColumns).Formula = "something"

and adapt it for your needs


"cornishbloke" wrote in message
...
Just when I thought I was getting better at using VBA I get stuck on
something that I'm sure should be simple :( :

in my spreadsheet I have a macro called "addrow" which adds a bordered
area of 6 rows and 7 columns to the bottom of the current table. This
macro uses a cell named "insertpoint" so that it knows where to insert
the copied area.