Copy macro/formula down a column, based on an adjacent cell

**eoghanmolloy** · 03-31-2014, 08:47 AM

I have what I am sure is a simple query, I have a macro that runs a VLOOKUP from C5 to P5 and what I need it to do is then run the macro in the cells in the rest of the columns, but as I have just inserted a blank column to put my macro in, it goes and copies down to the end of the sheet, so I would need to specify the range to copy it down but only if there is something in the previous column.

The column length will vary daily as the sheet is updated, so one day it needs to copy from C5:P5 to C500:P500 and the next day copy from C5:P5 down to C1000:P1000 and so on

I have managed to get it to copy text down but not my Macro/formula

Can anyone help please?

Thanks

**HaHoBe** · 04-01-2014, 12:46 AM

Hi, eoghanmolloy,

you might consider to share the solution you found with other users as this thread is marked as SOLVED.

Get the last row number of any column after inserting (assume you insert a Column in C get the last row in Column D) and use it as the upper limit for the loop:

Dim lngLastD As Long
lngLastD = Range("D" & Rows.Count).End(xlUp).Row

Ciao,
Holger

Copy macro/formula down a column, based on an adjacent cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Copy macro/formula down a column, based on an adjacent cell

Re: Copy macro/formula down a column, based on an adjacent cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] I need a macro to copy down till adjacent column ends in a blank cell

VBA Macro to autofill data in column based on value on adjacent cell

[SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.

[SOLVED] macro to autofil formula based on number of rows on adjacent column

[SOLVED] Macro to Copy Formula Down Until Data in Adjacent Column Becomes Text

Bookmarks

Bookmarks

Posting Permissions