Thread: With Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin H. Stecyk[_2_] Kevin H. Stecyk[_2_] is offline
external usenet poster
 
Posts: 43
Default With Statement

Hi,

I am doing something incorrect.

With Range("$A$3")
..Text = "Current Configuration"
..Font.Bold = True
..HorizontalAlignment = xlLeft
With .Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
End With
End With

When the cursor hits the Text line, it crashes with "Run-time error '424':
Object required.

What am I doing wrong.

Also, can I nest a With Statement within a With Statement?

Thank you.

Regards,
Kevin