View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sousas sousas is offline
external usenet poster
 
Posts: 1
Default Duplicating rows and changing cells

I am very new to VB programing and already found myself in a problem.
want to split some rows with info according with some cells values o
col A and B. And When i split those rows i also want to change th
value of those cells. For example:

I want to transform this:

1 1 MP3_Music
2 3 Wave_Music
4 4 MP3_Music

Into:

1 1 MP3_Music
2 2 Wave_Music
3 3 Wave_Music
4 4 MP3_Music

I though in using a ABS to see if i have a difference in a row. If tha
was true then the macro would add a new line. My problem is making th
macro search for for every difference for 200 or 300 lines and chang
them.

Is probably a dumb question but as i said before i am very new t
this..

TIA

Vito

--
Message posted from http://www.ExcelForum.com