Change hard code to Variable syntax
 

Stuart,

Try

LastRow = Application.Max(.Cells(Rows.Count,£Col+2) _
.End(xlUp).Row, .Cells(Rows.Count,£Col+3)) End(xlUp).Row, _
.Cells(Rows.Count,£Col+4)) End(xlUp).Row)


--

HTH

Bob Phillips

"Stuart" wrote in message
...
LastRow = Application.Max(.Range("H65536") _
.End(xlUp).Row, .Range("I65536").End(xlUp).Row, _
.Range("J65536").End(xlUp).Row)

is given code that works perfectly for the type of sheet it
was designed for. I would like to extend its' use by using
'£Col + 2' to represent col H, +3 for I and + 4 for J.

What is the correct syntax for this, please?

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003