Change hard code to Variable syntax
 

Hi Stuart,

Try to substitute Range() by Cells(). For example: Range("H65536") by
Cells(65536, 8)


HTH

---
Orlando Magalhães Filho

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)

"Stuart" escreveu na mensagem
...
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

Change hard code to Variable syntax
 

Many thanks to you both.

Regards.

"Orlando Magalhães Filho" wrote in message
...
Hi Stuart,

Try to substitute Range() by Cells(). For example: Range("H65536") by
Cells(65536, 8)


HTH

---
Orlando Magalhães Filho

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)

"Stuart" escreveu na mensagem
...
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






---
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