| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop column A and delete and move on condition
Hi,
I'm trying to loop through cells in column A (say rows 1 to 500) and if the length of contents is 0, clear contents as there will be apostrophes in the cells. If on the other hand the length of contents is greater than 0, I want to place the contents from column A in column C of the same row, whilst removing the contents of column A. I've tried various pieces of code but run into Debug mode! Thanks, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move column on condition | Excel Worksheet Functions | |||
| move from one column to another after a set condition | Excel Worksheet Functions | |||
| how do i move from one column to another after a set condition | Excel Worksheet Functions | |||
| Loop until a condition is False | Excel Programming | |||
| two-condition loop | Excel Programming | |||
Threaded Mode
