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

Thank

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements