| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move two columns to the right and then find next cell above that i
nonemtpy and move two columns two the right and then paste data?
How do I do that? br Sverre |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move two columns to the right and then find next cell above that i
Let's say your non empty is A5
Range("A5").offset(0,2).value = range("A5").value if you need to do this for a range then For each cell in Range("A5:A50") cell.offset(0,2).value = cell.value next cell -- JNW "sverre" wrote: nonemtpy and move two columns two the right and then paste data? How do I do that? br Sverre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: mouse cant find cell handle to drag/move | Excel Discussion (Misc queries) | |||
| move multiple columns into single set of columns | Excel Discussion (Misc queries) | |||
| Find text and move it to other cell | Excel Programming | |||
| vba code to find ssn and move two columns | Excel Programming | |||
| Move Cell in Column A to Column B when FIND | Excel Programming | |||
Linear Mode
