Hello!

I am creating a 'shared' workbook that users input data into and
would like to create a macro the user can use to put a new row in an
fill it with the required formula's.

The problem I am having is that I am trying to use Offset to put th
formulas in to the various columns for the row and I am stuck on
formula.

How would I use Offset for this formula:
=IF(A96="","",AO96&" - "&VLOOKUP(AQ96&AR96,CompLookUp,2,0))

This is what I tried:
.Offset(0, 12).Formula = "=IF(A" & .Row & "="","",AO" & .Row & "&"
"&VLOOKUP(AQ" & .Row & "&AR" & .Row & ",CompLookUp,2,0))"

It isn't working...Am I trying something too complex? Is there
better way? Help!
Mik

--
Message posted from http://www.ExcelForum.com