|
I was wondering if anyone can tell me why this code won't work or if there is a better way to autofit column "A" using code for VBA in excel.
Thanks
Set rngCurrent = shtSales.Range("A:A").EntireColumn.AutoFit
Set rngCurrent = rngCurrent.Offset(rowoffset:=1, columnoffset:=4) _
.Resize(rowsize:=rngCurrent.Rows.Count - 1, columnsize:=1)
|
|
|
|
|
|
|
// |