vba loop in excel

[Bebe]

could someone help me out with the syntax on a loop that would change this
0
0
0
0

into "a" as many times as it might appear it has no set row count each time?????

[Thomas Halsvik]

Wow. That was hard to understand. Start using punctuations and commas to make yourself better understood.

I understand this as a search and replace routine for all cells containing "0". You want to replace the "0"s with "a"s, right?

Do something like this

For y = 1 To NoOfRows
  For x = 1 To NoOfColumns
    If ActiveSheet.Cells(x,y)=0 Then ActiveSheet.Cells(x,y)="a"
  Next x
Next y

[coox]

Or you could just cheat and use:

    Cells.Replace What:="0", Replacement:="a", LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False

Which would be cheating, but would work very quickly...

[Bebe]

i can't get the first example to work -- are x and y variables that i need to give a value to???? help