blank column

  1. S

    Blank column not showing in pivot table set

    I have a calculated field Blank:=BLANK() The only purpose of this field is to insert a blank column in my pivot table. This works fine. But when I create a set of the pivot table the blank column disappears while in the MDX statement it shows the blank column. I formatted the blank field with...
  2. D

    copy to empty column

    i would like to paste my manually copied columns to another sheet next to an empty column. and start paste on column E if not empty using a command button as trigger like if i manually copy column B from sheet1 and paste it to sheet2 column E if not empty.
  3. J

    vba to copy cells where column is blank

    Hello all, long time lurker first time poster... This website and others have been really helpful to me in the past and I'm looking for a little more help now. I am looking for vba code that will allow me to copy cells in columns A and B that correspond to empty cells in columns C, D, and E...
  4. A

    Macro line to check if column is blank

    Hi guys In my project, I only want a certain If command to run in a particular column has at least one non blank cell in it. So if column J has a value in it, then I want this If command to run. I tried the following code but got runtime error 13: If Columns(10) <> "" Then If... Then...
  5. L

    Remove blank in pivot table without pivot filter

    Hello, I have a pivot table issue with blank columns and rows in my pivot table. How can I remove this WITHOUT the filter in the pivot table? the "-" indicate a completely blank cell. As you see, the column header and rows are blank. <TABLE style="WIDTH: 431pt; BORDER-COLLAPSE: collapse"...
  6. B

    Pivot Table Showing Blank Column Header

    I have a pivot table a column header containing 3 values to indicate if someone has completed an assignment. Specifally, the values are (1) complete (2) in progress (3) not started. The row variable is a specific line of business groupsand provides completion counts. So, the table tells me...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top