i'd suggest declaring a worksheet variable for ease of use:
then to point that variable to the right template use this line below (i can't tell which sheet contains the selection - for the purpose of this answer i will assume it's in a sheet named "Summary" and the template selection is sitting in cell a3 of that sheet)
dim whichTemplate as worksheet
set whichTemplate = thisworkbook.worksheets(thisworkbook.worksheets("Summary").range("A3").value)
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
I just started using excel about 3 months ago, if I attach the workbook, do you think you can rewrite the code? I have no idea how to write code, I copied that code from a forum. Thank you for the quick reply though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks