Experts Required..

[VBABEGINER]

Hi, from yesterday i was now, gone mad for this code.
just simple code, 1000 times giving

Cells(fn, "B") = "LOAD SUMMARY:"
Range(Cells(fn, "B"), Cells(fn, "C")).Merge
Range(Cells(fn, "B"), Cells(fn, "C")).Font.Bold = False
Range(Cells(fn, "B"), Cells(fn, "C")).HorizontalAlignment.xlCenter

Is this syntax right or wrong?

 

[Domenic]

Try...

Range(Cells(fn, "B"), Cells(fn, "C")).HorizontalAlignment = xlCenter