vba: autofill dynamic range / error

[Rotating_Potato]

0down votefavorite ​

Hi there, My code is: <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;"> Sub autofill_dynamic() Workbooks(file_main).Worksheets("sheet1").Activate ActiveSheet.Range("R52").End(xlDown).Activate ActiveSheet.Range(ActiveCell, ActiveCell.Offset(0,198)).Select Selection.AutoFill Worksheets("sheet1").Range(Selection, Selection.Offset(-61,0)) EndSub </code>What I'm trying to achieve: move to the bottom of the data from the selected cell R52, select all the cells by offsetting to 198 cells, and autofill the table to the top by 61 cells up. The subroutine provides me with the error 1004 (the operation requires the cells to be identical in size). I did unmerge all cells in the range.

<tbody>
</tbody>

 

[Lee.]

If you are going to cross-post - make it less obvious and don't include the hyperlink from where you have copied and pasted!

 

[MARK858]

@ Lee, actually if the poster is going to cross-post then they should post the link and actually make it more obvious as per the forum rules

Rule #10:
We prefer that members do not cross-post questions to other forums, but when this does occur members should make clear that they have cross-posted and provide links to the cross-posts. Cross-posted questions that do not comply may be deleted or locked. Serial offenders may have their posting privileges revoked. For a discussion on the issues with cross-posting, see this link: Excelguru Help Site - A message to forum cross posters

 

[Lee.]

@ Lee, actually if the poster is going to cross-post then they should post the link and actually make it more obvious as per the forum rules

I know - but how he's done it though is very unintentional. It's more luck, than judgement

 

[Rotating_Potato]

@ Lee how do you know?

 

[MARK858]

New thread started