Select 500 lines from a table

[DaveSwanton77]

Help,

I have a list of data and would like to select the bottom 500 lines of the data using VBA and hightlight them in red. The number of lines is not static and could be between 1500 and 2000 rows and 5 columns wide

Thanks

Dave

[Ivan F Moala]

On 2002-05-21 07:57, DaveSwanton77 wrote:
Help,

I have a list of data and would like to select the bottom 500 lines of the data using VBA and hightlight them in red. The number of lines is not static and could be between 1500 and 2000 rows and 5 columns wide

Thanks

Dave

Hi Dave this will colour last 500 in ColumnA
red;

Sub Tester()

'Color last 500 Red

Range([A65536].End(xlUp), [A65536].End(xlUp).Offset(-499, 0)).Interior.ColorIndex = 3



End Sub