ExcelBanter - easy!!!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - easy!!!! (https://www.excelbanter.com/excel-programming/374511-easy.html)

John

easy!!!!

How can I get this one to work?

colm = ActiveCell.Column
Selection.AutoFill Destination:=Range(Cells(4, colm), Cells(35, colm))

Trevor Shuttleworth

easy!!!!

ActiveCell.AutoFill _
Destination:=Range(ActiveCell, _
Cells(35, ActiveCell.Column))
Regards

Trevor

"John" wrote in message
...
How can I get this one to work?

colm = ActiveCell.Column
Selection.AutoFill Destination:=Range(Cells(4, colm), Cells(35, colm))

All times are GMT +1. The time now is 12:43 PM.