I am moving a table to excel and have been successful.  Now I am trying to 

get fancy and format the spreadsheet from VBA.  I am using the R1C1 type 

of referencing.  This is causing me trouble.  I am using the following 

code:

    With wbNew 

        .Styles.Application.ReferenceStyle = xlR1C1

    End With

    

    With wksNew 'worksheet

        .Range("R1C1:R1C29").Font.Bold = True



This "R1C1:R1C29" does not work.  However if I substitute, "A1:CC1" it 

does work.  I need the fexibility of using a variable to determine the 

last column.  I cannot do that if I am using letters of the alphabet. Does 

anyone know the correct syntax so that I can use the R1C1 style of 

referencing?

You may want to consider the Cells() function of referring to individual

cells via a for next loop traversing mechanism.

Walt, that did the trick. Within the next geological epoch, I too will be 

a VBA programmer.

Thanks, 

Terry Franklin



You may want to consider the Cells() function of referring to individual

> cells via a for next loop traversing mechanism.

> 

> 

> 

>