ExcelBanter - View Single Post - Excel macro

Victor Delta[_2_]

In article , lid says...

In article , lid says...

Call Copy_Title

Where's the code for this?

Surely you don't need that? The Copy_Title works perfectly and will
do so when called from this macro?

So how does it know which cell to act on???
Your 'With Cells(x, y) doesn't work because Copy_Title is not a
method of the Cells object...

Thanks. So perhaps that's where I was going wrong...? What I tried to
write was a macro that would go up column G, calling the Copy_Title
macro every time it got to a cell where the cell and the one above were
blank. (This is exactly what I do manually at present!)