Mike

You may find these links instructive

http://www.dicks-blog.com/excel/2004...eet_formu.html
http://www.dicks-blog.com/excel/2004...t_formu_1.html

I generally use the Address property when building formulas, like

With Range("B80").Offset(0, 12)
.Formula = "=IF(" & _
.Offset(16, -13).Address(0, 0) & _
"="""",""""," & _
.Offset(16, 27).Address(0, 0) & _
")"
End With

which will return

=IF(A96="","",AO96)

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com


"miker1999 " wrote in message
...
Hello!

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

The problem I am having is that I am trying to use Offset to put the
formulas in to the various columns for the row and I am stuck on a
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 a
better way? Help!
Mike


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