Thread: Print range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default Print range

Hi
I have a worksheet(sheet1) containing data relating to holidays
in column A i have the Week number that corresponds with the date in Column B

What i would like to do is :-
Enter a week number in a Cell ie 6
on the click of a button i would like to print the range the relates to week 6
or any other week i select


thanks

kevin