Avatar of thutchinson
Flag for United States of America

asked on 

Excel VBA to move a specific number of positions

I need a macro that will move down a worksheet and duplicate each record.
Then, I need to select every other cell in a column and move the value in the selected cell left one column.
Question:  How do I specify in VBA that I want to move, say, 2 cells down or 1 row down and then 2 rows left?

Thanks in advance for your help.
Microsoft ExcelVB ScriptVBA

Avatar of undefined
Last Comment

8/22/2022 - Mon