tabname

Hi, I have the below code which works well. I have 18 tabs in total and they change all the time apart from 2 or 3. However I now only want the list to start after the "template" tab which is the 4th tab. Can anyone tell me what I need to add to the below for this to work? Sub Listalltabs()...

Hello I have a macro that create automatically new Sheets and on each Sheet create a Table The Table Name is based on Sheet Name ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:G1"), , xlYes).Name = "Tab_" & ActiveSheet.Name Excel replace space and other characters on the Sheet name with...

I have a single workbook with several worksheets. I would like to generate a list of names and have them added to my sheet named "Data", in column L which has a header in L1 of "Sheets Names". Each sheet has the tab name listed in cell CA1. I have the code listed below to generate the list of...

Hi, i'm trying to vlookup some comments from different workbooks but with the same name. so i stored the names in an array. i got 2 problems here, 1. first vlookup runs without an error but doesnt return any result 2. second vlookup gives error 1004; Application-defined or object deifned error...

Hi, i'm trying to vlookup some comments from a different workbook with its sheets names stored in array. i have two problems here. 1. The first vlookup runs without an error, but i didnt get any results 2. The second vlookup gives error 1004 ; apllication-defined or object-defined error For...

trying to fill a range of blank cells with the name of the sheet that they are in. not sure why Range("ActiveSheet.Name") does not work? any help appreciated! Dim rng As Range Set rng = Range("B1:B100") For Each cell In rng If cell.Value <> "" Then cell.Offset(0, -1).Value =...