header name

Good day to you. I'm trying to revamp a bit of VBA code based on unknown column locations, known only by their header names. :cool:This first bit of code is working properly as it should: Private Sub STEP4_Separate_Name() ' '''''''''''''''''''''''''''''''''''''''''''''Insert 4 columns to...

Hi Guys! I have the code below to sort my table, but this sheet is downloaded from a system and the columns change position from time to time. Is there a way to execute the code below using header's names? Range("A1").CurrentRegion.Sort _ key1:=Range("AY1"), Order1:=xlAscending, _...

All, Excel 2010 shows a neat feature when data is imported from SharePoint. It customizes its own column headings. When you scroll down A is replaced with the content of A1, B replaced with B1 etc. This has nothing to do with the view headings checkbox as this is checked in both cases. I would...

hi find blanks cell in column and take header name in remarks , I need to remove last comma and add last sentence, if only one blanks cell is there add at last ( is not available ) if more than 2 blanks cell need to add at last ( are not available ) formula used in remarks...