wsNew.Name
h
If I am using wsNew.Name= c.value in a macro, how do I change that to only use a certain number of characters... ie wsNew.Name= Left(c.value, 5) --- Which isn't right, but that's the idea of what I want to d Thanks. |
wsNew.Name
Allie wrote:
hi If I am using wsNew.Name= c.value in a macro, how do I change that to only use a certain number of characters.... ie wsNew.Name= Left(c.value, 5) --- Which isn't right, but that's the idea of what I want to do Thanks. What's wrong with that Left() line ? -- Regards, Juan Pablo González |
wsNew.Name
Probably would help if you showed us more of the code.
-- Don Guillett SalesAid Software "Allie" wrote in message ... hi If I am using wsNew.Name= c.value in a macro, how do I change that to only use a certain number of characters.... ie wsNew.Name= Left(c.value, 5) --- Which isn't right, but that's the idea of what I want to do Thanks. |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com