| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help to copy in a range
I given the following command to copy in a range upto end of the column of that cell in a macro. the error message is 'Autofill mathod range class failed ' given by the system But it is not working . Please help me with correct command Selection.AutoFill Destination:=Range("O2:O" & Cells(Rows.Count, "O").End(xlUp).Row) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help to copy in a range
Hi,
You must copy the range before filling. Try this Selection.Copy Destination:=Range("O2:O" & Cells(Rows.Count, "O").End(xlUp).Row) Mike "pol" wrote: I given the following command to copy in a range upto end of the column of that cell in a macro. the error message is 'Autofill mathod range class failed ' given by the system But it is not working . Please help me with correct command Selection.AutoFill Destination:=Range("O2:O" & Cells(Rows.Count, "O").End(xlUp).Row) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help to copy in a range
thanks a lot
"pol" wrote: I given the following command to copy in a range upto end of the column of that cell in a macro. the error message is 'Autofill mathod range class failed ' given by the system But it is not working . Please help me with correct command Selection.AutoFill Destination:=Range("O2:O" & Cells(Rows.Count, "O").End(xlUp).Row) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help to copy in a range
"Mike H" wrote: Hi, You must copy the range before filling. Try this Selection.Copy Destination:=Range("O2:O" & Cells(Rows.Count, "O").End(xlUp).Row) Mike "pol" wrote: I given the following command to copy in a range upto end of the column of that cell in a macro. the error message is 'Autofill mathod range class failed ' given by the system But it is not working . Please help me with correct command Selection.AutoFill Destination:=Range("O2:O" & Cells(Rows.Count, "O").End(xlUp).Row) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Copy Used Range | Excel Discussion (Misc queries) | |||
| copy a specified name range | New Users to Excel | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
Linear Mode
