Increasing the width/height of cells programatically

  • Thread starter Thread starter sameerce
  • Start date Start date
S

sameerce

Hi,
I have made an Excel VBA application where new sheets are automaticall
added on button click. I wanted to know how one can change the name o
the new excel sheet created and more importantly how does one chang
the width and height of cells in the new sheet.

Thanks,
Samee
 
Hi Sameer
Try and use the macro recorder.
Here's a sample code though:
Sheets.Add
ActiveSheet.Name = "Sheet11"
Rows("2:2").RowHeight = 20
Columns("B:B").ColumnWidth = 20

HTH
Cordially
Pascal
 
Try the following to change the whole worksheet column width and row heights


Sheets("Sheet1").Name = "YourName"
Cells.ColumnWidth = 15.5
Cells.RowHeight = 25.5

Cheers
Nigel
 
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

Adjusting row heights and column widths to align with another sheet 1
Auto-Calculate price based on width x height 0
Row height & Column width locked? 1
Have the width/height of a autoshape placed in a cell 2
Position Userform In Cells Portion of Excel Only 1
The size of the ActiveX ListBox control shrinks 2
Running out of memory when adding logos to reports 2
Screen tip indicators missing - Row Height, Column Width 3

Back
Top