I have a excel sheet with 5 columns (A,B,C,D,E). I want to wite a macro to select column D and E and then change its font color. I have merged cells in Column A. What happens is that due to merged cells when i write the statement
         columns ("D:E").select or Range("$D:$E").select
it selects the whole sheet(from column A to column E). Could someone suggest a wayout to select column D and E only with merged cells in Column A.

Thanks

Ajitpal S Padda

__________________
Ajitpal S Padda

Loop through all rows and check if the MergeCells property is set to True for the cell in column A. Here's an example (don't forget to set myStartRow and myEndRow):

For n = myStartRow to myEndRow
  If Cells(n,1).MergeCells = True Then 'Cell in column A is merged with another one
    Cells(n,1).Font.ColorIndex = 5 'Changes the font color to blue
  Else 'No merged cell
    Range(Cells(n,4),Cells(n,5)).Font.ColorIndex = 5 'Changes the font color to blue
  End If
Next

Note: this is not as fast as selecting columns, but it works...