View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_21_] Craig[_21_] is offline
external usenet poster
 
Posts: 39
Default VBA code manipulation cells

Hi there,
It is possible with vba code to click a button or 5 buttons in this case to
select the appropriate cell, A1, A20, A40, A60, A80.... as the selection is
made I would like the selected cell to be in the upper left corner, so if I
clicked Cat we would scroll down to cat and row 20 would be the first row
seen? Thanks Craig
A B C
1 Dog

20 Cat

40 Bird

60 Lion

80 Tiger