Rows Autofit

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

I try to set autofit for rows but got error
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).row
rows("2:lastrow").autofit
 
Try:

rows("2:" & lastrow).autofit


I try to set autofit for rows but got error
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).row
rows("2:lastrow").autofit
Click to expand...
 
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

Need macro to delete rows not containing certain text 0
Help addressing the last cell 1
Help on setting a range 2
Help with Autofit Row Height Macros 2
excel importing data 16
Wrap text and row autofit 2
combining row values into one cell while filter is active 6
Run two macros for two different sheets 11

Back
Top