Hi all,

I currently use a sheet that has a table in the middle. The number of rows and columns varies, I then delete the blank ones. Each cell holds a formula retrieving the data from another sheet. Does anyone know any code that can delete these empty rows and column cells. Even if it just deleted empty rows (which include formulas it would be great).

SHEET
|----------------------------------------
|
| INFO
|
|-------------------------------
| a 1 aa ww | Table
| b 2 bb gg | (need to delete empty
| c 3 cc jj | rows and column cells)
|d 4 dd jj1 |
| |
|-------------------------------
|
| INFO
|
|
-----------------------------------------

Appreciate any help with this
Gar Toms

I have solved this. By copying the table and paste special the formulas are removed. Conventional code to delete blank rows can then be used.

I still however cannot remove the cells in the column but i can live with that.