Thread: Setting a Worksheet Name as a Variable Help
View Single Post
 
Old 11-25-2016, 08:50 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Remove .Name from DestSh.Name

What that line is saying...
If the sheet name of the sheet being considered is not equal to the variable DestSh
Reply With Quote