Last Cell

[Michael Smith]

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!

 

[Bob Phillips]

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

etc.

--

HTH

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

 

[Cesar Zapata]

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

 

[Michael Smith]

Thank you both!


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