StuR

Hi,

Fairly new to macros, and self-taught, so have probably missed all the basics!

I am using macros to manipulate a number of tables which have been pasted from .txt format to a single excel sheet (ctrl+A, ctrl+C, select sheet, scroll down to next free row, select cell in column A, ctrl+V). Each table has a header row, with 'group' in column A, then the rest of column A is blank. This leads to column A being 'blank' except for 'group' interspersed at irregular intervals.

I have made a looping macro which goes up Col A and enters the date corresponding to that table into each blank row, hits 'group', activecell.offset(-1,0), change date etc until there are no empty cells in Col A. This works fine, but is slow (table could grow to >50,000 rows).

I have tried to speed it up by selecting range(activecell, activecell.end(xlup)).select, which only works after I go down the column, manually select the blank cells and press delete... I have tried using something selecting (xlCellTypeBlanks).delete, but this doesn't work.

Is there data in these 'blank' cells, and can I prevent it forming/get rid of it?

Thanks in advance

venkat1926

the question is not clear.

why not just sort according to column A.