niloyparvaz
New Member
- Joined
- Dec 16, 2009
- Messages
- 14
Hi
So basically I am trying to create new worksheets based on a range of rows. For instance if i have a range of A1:F1 and I want to check this range and see if there are any values which corresponds to the name of a worksheet already, if not then create a new worksheet naming it according to the value of the row. I know its a really easy bit of coding but I am an amateur in VBA and I would really appreciate it your help. Thanks
So basically I am trying to create new worksheets based on a range of rows. For instance if i have a range of A1:F1 and I want to check this range and see if there are any values which corresponds to the name of a worksheet already, if not then create a new worksheet naming it according to the value of the row. I know its a really easy bit of coding but I am an amateur in VBA and I would really appreciate it your help. Thanks