Hi,

i am making an excel file from visual basic With the following code:

Dim newbook as Variant
set newbook = X.Workbooks.Add
newbook.worksheets(1).range("A1").Value = "bla"
newbook.worksheets(1).range("A1").Font.Bold = true



This works fine, but there are a few things that i don't know how to do:

Changing column width and row height
changing the cell backcolor

Could anybody help me please?