Using buttons in Worksheet
 

Hi,

I have a report to prepare..

Objective is when you click on say button 1 it should show line 6-10
and click on button 2 it should show line 15-20 etc..

Basically they wanted to create you know like have 3-4 buttons and each
one of that have to show some specific lines in the worksheet..

Any help on this would be great guys..

Rgds

Vj

Using buttons in Worksheet
 

Private Sub CommandButton1_Click()
Rows("6:10").Select
End Sub