ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Column Reverse AutoFill. Is this possible? (https://www.excelbanter.com/excel-programming/373818-excel-column-reverse-autofill-possible.html)

MGSurberDallas

Excel Column Reverse AutoFill. Is this possible?
 
Is is possible to go to the last cell in a particular column, copy that data,
then perform a reverse autofill??

Trevor Shuttleworth

Excel Column Reverse AutoFill. Is this possible?
 
For example:

Range("F20").AutoFill Destination:=Range("F9:F20"), Type:=xlFillSeries

You just need to establish the bottom of the range and the top of the range.
The source must be the cell at the bottom of the range.

Regards

Trevor


"MGSurberDallas" wrote in message
...
Is is possible to go to the last cell in a particular column, copy that
data,
then perform a reverse autofill??





All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com