AmardeepD
02-20-2008, 03:17 AM
Ok so I am trying to get my code to change the appearance of text in cells. I have managed to get it to change the font to bold but i cant seem to get it to change the alignment. For bold/unbold the code is
Worksheets("Sheet1").Range("A51").Font.Bold= 'True or false
However i cant seem to figure out an equivalent for aligning the text. Its a stupidly simple problem and probs wont take 5 seconds for someone who knows how... Ignorance is NOT bliss! lol
Worksheets("Sheet1").Range("A51").Font.Bold= 'True or false
However i cant seem to figure out an equivalent for aligning the text. Its a stupidly simple problem and probs wont take 5 seconds for someone who knows how... Ignorance is NOT bliss! lol