Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not Hard Code If | Excel Discussion (Misc queries) | |||
Syntax for variable search | Excel Programming | |||
Syntax for variable search | Excel Programming | |||
Syntax for variable search | Excel Programming | |||
Syntax for variable search | Excel Programming |