Macro to delete all blank cells

I am doing a chart that is dependent of a summary table from other sheets.
As I choose a client, some cells in the summary table become blank and the
graph treats them as a 0. How can I create a macro that will open a sheet in
a workbook copy and paste values into the table and then delete the blank
cells (like clicking the delete key in eac cell). That seems to fix it, but
I cannot do it automatically.

Thanks

You can record a macro to do this if you want. As a guess the only part you
are missing is to select all of the empty cells, hit the F5 key Select
Special and then select empty cells...
--
HTH...

Jim Thomlinson


"Brian" wrote:

> I am doing a chart that is dependent of a summary table from other sheets.
> As I choose a client, some cells in the summary table become blank and the
> graph treats them as a 0. How can I create a macro that will open a sheet in
> a workbook copy and paste values into the table and then delete the blank
> cells (like clicking the delete key in eac cell). That seems to fix it, but
> I cannot do it automatically.
>
> Thanks

Hi Jim, How are you???
could you chek the discution below this one???
TIA

"Jim Thomlinson" wrote:

> You can record a macro to do this if you want. As a guess the only part you
> are missing is to select all of the empty cells, hit the F5 key Select
> Special and then select empty cells...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Brian" wrote:
>
> > I am doing a chart that is dependent of a summary table from other sheets.
> > As I choose a client, some cells in the summary table become blank and the
> > graph treats them as a 0. How can I create a macro that will open a sheet in
> > a workbook copy and paste values into the table and then delete the blank
> > cells (like clicking the delete key in eac cell). That seems to fix it, but
> > I cannot do it automatically.
> >
> > Thanks