Code to delete rows and column cells that have formulas in.

G

GarToms

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
|
|
 
G

GarToms

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.
 
Top