little code - simply turns a cell color black:


Option Explicit

Sub Pardhu()

Dim wb As Workbook
Dim ws As Worksheet
Dim myRange As Range

Set wb = ActiveWorkbook
Set ws = ActiveSheet
Set myRange = ws.Range("a3")

myRange.Interior.Color = vbBlack

MsgBox "Look! It's black!", vbOKOnly


End Sub


hope it helps
susan


On Nov 2, 2:53 am, Pardhu wrote:
Hi , everybody

I am just in to excel vba programming. can any
body give me some small sample programmings. so that i can start
working my self.

Thanks