Formula to start on next blank line

[hk1620]

Hi I have the below macro which is supposed to insert a formula to the next blank row. It is giving me an error. Does anyone have any insight as to why?

Range("A1").End(xlDown).Offset(1, 0).Select
ActiveCell.FormulaR1C1 = "=IF(RC[15]="""","""",RC[15])"
Selection.AutoFill Destination:=Range("A2:A" & Range("L" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select

Thank you!

[jolivanes]

Copied from the help file.

This example performs an autofill on cells A1:A20 on Sheet1, based on the source range A1:A2 on Sheet1. Before running this example, type 1 in cell A1 and type 2 in cell A2.

Visual Basic for Applications

Please Login or Register  to view this content.

If you explain what you want to achieve, someone will supply you with proper code.

[Artik]

Study these three procedures:

Please Login or Register  to view this content.

Artik

[jolivanes]

This might be a possibility also.

Please Login or Register  to view this content.

[hk1620]

Thank you all for your responses. I am trying to copy data in the same worksheet, to the bottom of current columns. For example, data from R should be copied to the bottom of A.

[hk1620]

Thank you! I tried this, but all of my cell came out blank.

[jolivanes]

If we don't know the layout of your sheet it'll be guessing forever.
We don't know the last used cell in each column. Are they all filled to the same row? How may columns do have in use?
Do any columns need to be cleared before anything else happens?
Explain in detail. You know what your sheet looks like but we don't.

[hk1620]

Sorry, I just recently discovered this site. My spreadsheet goes from column A to GU. My goal is to copy some of the columns from L:GU to A:K. I am only copying 6 columns of data from L:GU. A:K are filled to the same row with data. After copying the the data I need, L:GU will be deleted. Nothing needs to be cleared. I currently have the macro set up and it does everything I need, except it pastes the data over the existing data in A:K.

[jolivanes]

A generic Copy and Paste would be something like
Add and change as required.

Please Login or Register  to view this content.

[hk1620]

Thank you! This seems to work, the only issue is that it copies the header row as well. Is there a way to exclude the header?

[jolivanes]

Start from the 2nd cell and resize 1 less

Please Login or Register  to view this content.

[hk1620]

You are amazing, thank you so much!

[jolivanes]

Thank you for letting us know that your happy.
Good Luck