I'm working on this Excel and VB project, where a table in Excel is 10 lines of data. There are few lines in the table which are blank. Like line 1 might have data, then line 2 and three be empty, and then line 4 will have data again. I'm looking for a code in VB which will only read the lines from the table which has data, copy them, and paste them into a different page in the same file.
Can anyone help me in finding a code for this.
