sheetname

Hi! I have a problem. I have a Workbook named 'SalesData.xlsx' which contains two sheets 'Demand' and 'Availability'. Column A of these worksheets contains CUSTOMER names and remaining thirteen columns contain month-year data. The following needs to be done with both sheets i.e. 'Demand' and...

This error message pops up when I run the macro, "Run-time error '9': Subscript out of range" I was wondering what could be wrong with the code? "Sheets(sheetName).Activate" is highlighted. THANKS!!! Here is my code: Function calAutoNumber(sheetName As String, StartCol As String, startrow As...

Hello, is there a way to use a formula to reference a sheet name. example... =(F3-14)!a1 Where F3 is a date and by misusing 14, the resulting product would be a new date. This new date would be a sheetname from which you would reference and use cell A1

Hi Guys, I nearly have my Macro finished stuck on one thing. I want to make Cell A4 my Sheet Name. Cell A4 contains both Letters and Numbers Cell A4 may start with a word eg 'property: 165666' I Just was the Number 165666 as my sheet name. Also After the property number I want the Letters...

Hi guys, I have a workbook which I'm not allowed to share or publicate. Inside the there are a lot of tabs, amongst them: '0' Start of Costcenter tab range '13134' one of the costcenter tabs '9' End of Costcenter tab range 'Config' a check/lookup/reference sheet. Between the '0' and '9' there...

Hello all, This is my first post here. I've searched the entire forum but couldn't find an answer for my situation. This is what I am trying to do; My sheet names are the dates of the month.. 07 Feb,08 Feb,09 Feb etc.. I want to sum up the values in a cell(for example L41) in every sheet from...

=""&MID(CELL("filename",Sheet1!$A$1),FIND("]",CELL("filename",Sheet1!$A$1))+1,256) 1. Change filename to the your workbook's filename. 2. Change Sheet1 to your current sheetname where you have pasted the formula. This formula below which I found on many forums doesn't really work because...

Hi, I need a code: If Sheet names in book1 which is opened does not match the value of F4 then add a new sheet and name it as f4.value Thanks for helping Pedie;)

Hi, The first part of my program is about a solver that creates a new sheet with the same format everytime it runs so the user can keep a trace of different scenarios. But now i have another sheet called "Data Comparison" and I want to define two cells where the user can add the name of the...

I am sorry if I am repeating a thread here, but I've tried to find something that will help me, and can't. I have a model which produces a new worksheet each time it is run - and old sheets are hidden from the user. I need to write some code that will take the names of all spreadsheets and...