Ray.Mason
06-20-2012, 12:42 PM
I am trying to develop a macro that copies cell data in a column range. However in this column range other cells are empty and I want the macro to ignore all empty cells. Ideally the macro will look into eg cell C9 then copy, then go into another cell within the range that contains data, copy until end of loop.
The code I have below works but selects individual cells within range.
Range("A8").Activate Do If ActiveCell.Value = "STOP" Then Exit Do ActiveCell.Offset(1, 0).Copy Loop
Can you please help me with ways I can amend my code to loop cell to cell that contain data and individual copy these cells. I will paste these into some bookmark (not an issue at the moment)
Many thanks!
The code I have below works but selects individual cells within range.
Range("A8").Activate Do If ActiveCell.Value = "STOP" Then Exit Do ActiveCell.Offset(1, 0).Copy Loop
Can you please help me with ways I can amend my code to loop cell to cell that contain data and individual copy these cells. I will paste these into some bookmark (not an issue at the moment)
Many thanks!