formatting a range

  • Thread starter Thread starter James
  • Start date Start date
J

James

I've selected a range as follows:

Set rng = Range(Cells(upperLeft(0), upperLeft(1)), Cells(lowerRight(0),
lowerRight(1)))
rng.Select
Selection.Font.FontStyle = "Arial"
Selection.Font.Size = 10
but the font size in some columns doesn't change. Any ideas?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Range to Another Workbook 6
Excel VBA 1
Copy Multiple Areas from One Workbook to Another 4
Runtime Error 13 - Type Mis-match 4
Array Copy - Paste Special Add Help 2
Baffled by calling a private function 5
Selection.AutoFill Destination:=Range 0
Object range failed 1

Back
Top