Posts by NoamG

    Re: Macro Problem

    The problem with your soilution is that the entire header row is colored yellow. I want to color only the cells that have data in them. Do you know how to do that?

    Hello All!
    I sometimes import data from an ERP Program to Excel.
    I want to write a Macro which will make the imported data more presentable (For example: draw borders for all the cells, give the heading a fill color etc. etc.). To do this I need to select the heading row.
    The problem is that each time there are a different number of columns.
    How do I program the macro so that it will color all of the header?
    I saw a macro that does this on a pivot table and I want to do thae same on a regular table.