highlight alternate row in excel
 

Dear Friends,

i would like to have a command or vba-code for highlighting alternate
row.
e.g. a1..h1, a3...h3, a5...h5, a7...h7

thanks

highlight alternate row in excel
 

See if this helps:

http://office.microsoft.com/en-us/ex...CL100570551033

"gopal" wrote:

Dear Friends,

i would like to have a command or vba-code for highlighting alternate
row.
e.g. a1..h1, a3...h3, a5...h5, a7...h7

thanks

highlight alternate row in excel
 

Since you are not doing an entire row, consider this method by Chip Pearson:

http://www.cpearson.com/excel/banding.htm

Mike F
"gopal" wrote in message
...
Dear Friends,

i would like to have a command or vba-code for highlighting alternate
row.
e.g. a1..h1, a3...h3, a5...h5, a7...h7

thanks

highlight alternate row in excel
 

here is some code that will do what you want

Sub banding()
Dim i As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
For i = 1 To 5 Step 2
ws.Range("A" & i & ":H" & i).Interior.ColorIndex = 37
Next
End Sub

--


Gary


"gopal" wrote in message
...
Dear Friends,

i would like to have a command or vba-code for highlighting alternate
row.
e.g. a1..h1, a3...h3, a5...h5, a7...h7

thanks