View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
berlead berlead is offline
external usenet poster
 
Posts: 1
Default Macro moving down the sheet cell by cell

I have successfully created a macro that copies and pastes data fro
three columns of a row into a single entry in a single cell in tha
same row. I am trying to get this macro to perform the same functio
in multiple cells directly beneath the row where I recorded it. Fo
example, I have it working in row 3. I want it to perform the sam
function in rows 4 through 200.

How do I get it to move down one row, execute, move down one row
execute, move down one row, execute etc and stay row relative...?

When I run the macro now, it always returns to row 3 and executes.

I am not a programmer and have very limited experience with macros (a
you can probably tell).

Thanks

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