VBA define region

[Guest]

Hi fellas,

Set LastCell = Range("B65536").End(xlUp)
Set CodeRange = Range(A2, LastCell).

ListBox1.RowSource = "'Officer Code'!a2:b33"

Need help with this... How do I define a range such that it starts from A2 and ends at LastCell ie the Set CodeRange line..

Then I want to set it as the RowSource to the ListBox... Any ideas guys??

Thanks

 

[Ivan F Moala]

Set Lastcell = Range("B65536").End(xlUp)
Set CodeRange = Range("A2", Lastcell.Address)

ListBox1.RowSource = CodeRange.Address

Ivan

 

[Dave Hawley]

Not eaxctly sure I have understood you but, try:

Sheet2.Range("A2", Sheet2.Range("B65536").End(xlUp)).Name = "MyRange"
ListBox1.RowSource = "MyRange"

 

[Guest]

Cheers guys