this question is related to the answer provided here http://www.experts-exchange.com/questions/28710206/copy-data-to-new-sheets-each-time-name-changes.html?anchor=a40956348
i am a excel learner, so i have two question on this code.
1- i added some new data with different in column B and Column A and then ran the macro then i get an error in line 11 and it says "Run time error 1004
Cannot Rename a sheet to the same name as another sheet a referenced object library or a workbook referenced by Visual Basic."
2- i got confused with "lastvalue" you have not set any value or i do not see any reference before for "lastvalue" can you please explain why have you used If c.Value <> lastvalue Then
lastvalue = c.Value becuase "lastvalue" obiously has no value and c.value is definitely is not equal to c.value , so wouldn't this work instead lastvalue=c.Value
grateful if you could shed light on this.