Macro Line Insert
I know this is an old thread, but maybe you can assisst.
I have a list of data and I would like to insert a row after a change in
data in column A.
Sample data
A B
State Code State
1 Alabama Total
Hence, I would like to create a macro insert a row when "xx state" changes!
Thanks,
Larry T
"Bernie Deitrick" wrote:
Frantic,
Columns("C:C").Find(What:="X", _
LookIn:=xlValues, LookAt:=xlWhole).EntireRow.Insert
HTH,
Bernie
MS Excel MVP
"Frantic Excel-er" wrote in
message ...
I was wondering if it is possible to insert a line without a direct cell
reference.
This is exactly what I am trying to do...
I have import files that have many different lines...(each one is unique).
I wrote a macro to go thru the many tedious steps, except I am stuck on
the
line insertion part....I do a data sort for column "C", and then I do a
find
for "X" (which is a separation point). What I want to happen is for the
macro to find "X" and insert a line above it, regardless of which row "X"
is
on. Is there a way to do that?
Thanks!!!
|