Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro that fills in one-line text in a variable range from sCell to
Range(sCell).cells(nRow,nCol). When I am done, I want to autofit the columns. Originally, I wrote Range(sCell).Resize(nRow,nCol).Columns.Autofit. Then I realized that this is autofitting based on only the new data. Data in pre-existing surrounding rows might require wider columns. If sCell were "B6" and nCol were 10, and I did this manually, I would select columns B through K, and click on Format Column Autofit. Recording a macro, that effectively does Columns("B:K").Columns.Autofit. How can I accomplish the same thing using the variables sCell, nRow and nCol? I think either I want a variable Columns(...) specification that encompasses the columns from sCell through sCell+nCol-1, or I want a variable Range(...) or Resize(...) specification that encompasses the rows from 1 through the last-used row of the columns from sCell through sCell+nCol-1. At least conceptually. I think. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't | Excel Programming | |||
Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't | Excel Programming | |||
Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
Autofit Columns | Excel Discussion (Misc queries) | |||
Columns.Autofit not doing what I want | Excel Programming |