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