VB MACRO ?
 

i want to make a button to highlight / color a range but
when i create the macro on one cell will color in...

here is the code ....

Sub Button1_Click()
'
' Button1_Click Macro
' Macro recorded 6/23/2004 by New User
'

'
Range("E3").Select
With Selection.Interior
.ColorIndex = 12
.Pattern = xlSolid
End With
End SubSub Button1_Click()
'

I am assuming where it states Range("e3").select

is the cell to highlight/ color but how can i change this
to be random or be aable to highlight more than one cell


Thanks in advance
David
'

VB MACRO ?
 

David

just delete the line "Range("E3").Select"

Regards

Trevor


"David ulrich" wrote in message
...
i want to make a button to highlight / color a range but
when i create the macro on one cell will color in...

here is the code ....

Sub Button1_Click()
'
' Button1_Click Macro
' Macro recorded 6/23/2004 by New User
'

'
Range("E3").Select
With Selection.Interior
.ColorIndex = 12
.Pattern = xlSolid
End With
End SubSub Button1_Click()
'

I am assuming where it states Range("e3").select

is the cell to highlight/ color but how can i change this
to be random or be aable to highlight more than one cell


Thanks in advance
David
'