column formatting

Hello, My question is: I have protected worksheets that I want to allow any end user to format the column width and the row height. I also want to allow any end user to group and ungroup existing grouped columns/rows. I have a VBA for the grouping issue - Private Sub Workbook_Open() With...

Hi Guys, I want the make change of the columns in a dynamic range from col H to AL. In each column, find if these text - "E", "G" and "N" appears only one, if conditions meet, trigger the change of that column I don't think I am using the correct dim and reference ! Please help. Private Sub...

Hi, How do I remove the (what I believe is) the column function formatting in a spreadsheet. Every time I build a formula the cell reference reads (for example) - =[@Column1415]. I just want it remove this formatting and for it to be the actual cell reference. Any help on how to do this would...

Hi - I have a spreadsheet with 150 columns across- in this particular section there are 5 rows I am specifically interested in highlighting using conditional formatting. There are 4 colors I am interested in conditionally selecting for these columns based on a specific value ( lets say, 1=...