Does anybody know what the syntax is for increasing the height of a row of an Excel spreadsheet?

Let's say I want to increase cell A1. I am having a compile error. I have the following syntax:

With objectExcel
     .cell(1, 1).row.height.value = 14.5
     .cell [some more codes...]
end with

This is my first time using an Excel spreadsheet as an output file. Please help me out.

I also wanted to get the contents of the cell to wrap into more than one line. Ex.

I want the street in one line and the next line in the same cell will be the city, state and zip. What is the syntax or command for this?



Thanks,
jmss66

Hello jms66

    objectExcel.Rows("1:1").RowHeight = 30.75
    With objectExcel.Selection
        .HorizontalAlignment = xlGeneral
        .VerticalAlignment = xlBottom
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With

I did'nt get any point on multiple lines. I guess, i saw was "Wrap Text"
and "shrink to fit". I say if you set row width and enable the Wrap text
it becomes and looks like its "multiple lines".

Anyway is just my thought.

hope this helps.

With Regards,
Raghavendra Mudugal

Thanks Raghavendra I will try and play with your code and see how I can make the "Wrap Text" work. Do you know any reference on the web or book I can buy so I can learn other syntax on Excel?

Thanks,
jmss66

Hello jmss66,

Actually, the best thing to learn is NO BOOKS, NO WEB LINKS.

Record a new macro, do what exactly you wanted to do to the CELL by changing
the properties font color whatever it can be..

afterwards, stop the macro.

Open the VBA editior of the excel from toolbar and see the code what it gave to
you. Then copy the code and put it under the excel object reference. IT WORKS !!!

This is what I do. Just consider this as a wizard to build the code what mouse/manual action you do.

Hope this helps.

With Regards,
Raghavendra Mudugal

Excellent suggestion. Thanks again for your help.

Cheers,
jmss66