Forum Discussion
Arcade_Printing
Feb 14, 2023Copper Contributor
using value in selected cell in macro
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
sheet1
sheet2 <---selected
sheet3
is there code that will take the sheet name of the cell that is selected
code now sheets("sheet2").select