Macro to change cell value

[rosellie]

Hi.... and help!
I'm a newbie to the forum and a newbie to VB but picking it up fairly quickly (the simple stuff, at least). I'm having to write some formatting macros at work and am so far doing ok but there's just one step I just can't seem to get as it involves conditionally changing a cell value and then the cell alignment. I've tried various IF functions but have concluded that the only way to do this must be through the macro... here goes....

I'm using Excel Report Generator to extract data from my database into the Excel template I'm creating the macro for. The sheet that I'm having issues with is because sometimes there will be no data for the period. What my boss wants me to do is set up the macro to include a step where it looks to see if the top row is blank and, if it is, to merge the row (I'm trying to sell 'Center Across Selection' to her) and type 'None' so that the client receiving the report doesn't go looking for data that doesn't exist. Merging has been a nightmare so I've settled for conditionally formatting borders and the whole =IF(..., then "NONE") has left me with a bruise on my forehead from banging it against my desk. Help??


Thanks so much!