Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to delete all blank cells
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to delete all blank cells
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Delete blank cells in a row | Excel Discussion (Misc queries) | |||
Macro to Delete blank cells | Excel Worksheet Functions | |||
Delete blank rows Macro | Excel Discussion (Misc queries) | |||
Using a macro to delete all blank rows | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming |