Copy,shift + Ctrl, arrow down MACRO


J

jd64361

Hi I created an Use relative reference macro in order to fill out the
blanks in a column that changes tittle every few hundred cells.
Sub add()
'
' add Macro
'
' Keyboard Shortcut: Ctrl+w
'
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.Range("A1:A961").Select
End Sub
the problem is that the macro is stoping in the same range than i
created instead of going down until find the new title and stop there.


columns
A
Rows Nancy This an example of what I am trying to do
can I created a macro tha selects
Nancy a paste it until find the next
title "Carol on this case" a stop
there?









Carol



Martha


Thank you!!
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top