Last Cell
 

I want to put a formula 2 rows below my last line of data, in the L,M,N
columns. Some kind of offset xlend thing?

TIA - mike



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Last Cell
 

range("L1").End(xlDown).Offset(2,0).Formula = ...

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael Smith" wrote in message
...
I want to put a formula 2 rows below my last line of data, in the L,M,N
columns. Some kind of offset xlend thing?

TIA - mike



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Last Cell
 

are the data on all columns that same lenght? if so then try this

sub TestThis()
irows = Cells(Rows.Count, "L").End(xlUp).Row + 2
Cells(12, irows).Value = "hello"
Cells(13, irows).Value = "hello"
Cells(14, irows).Value = "hello"
End Sub


Cesar Zapata

Last Cell
 

Thank you both!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!