I need to apply some formatting and dragging down of formulas using a Macro (I have lots of these) on a number of spreadsheets. Unfortunately the range that I need to do this varies from spreadsheet to spreadsheet in terms of the number of rows.

At the bottom of the rows that I need to apply the changes to is a number of cells that have unique information that could be used for reference. What I would like to be able to do is use a macro that looks for some specific cell content to identify the cell – then use that cells coordinates to then determine the row number that the formatting and formula needs to be dragged down to.

I’m pretty new to VBA and this has really stumped me and I’ve had no success from using google searches and trawling support sites.

This is kind of what I’m trying to do…

From the active cell – select a range (of adjacent cells)
Identify the bottom row that the changes need to be made to by using the identifier cell beneath it.
Drag down the range of selected cells to the bottom row identified above.

I hope this makes some kind of sense and any help would be really appreciated.