i have a simple macro to print out a sheet. i want to have all sheets listed down a column and then select the sheet and then print.
in the code sheets("sheet1").select
is there code that will take the sheet name of the cell that is selected
code now sheets("sheet2").select