using value in selected cell in macro

Copper Contributor

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


sheet2    <---selected


is there code that will take the sheet name of the cell that is selected

code now sheets("sheet2").select

1 Reply