blank columns

  1. P

    VBA - Pasting 2d Array to worksheet. Why is it producing a blank column with everything shifted 1 column across?

    I'm trying to paste the dynamic array OutputArray to the worksheet starting in cell Q8 which I've given the name UniqueEntitiesOutput ReDim OutputArray(1 To UniqueOutputs, 3) The code then populates OutputArray and I now want to paste it to the worksheet Here I've used select just so that you...
    • PTP86
    • Thread
    • blank columns missing columns pasting 2-d array
    • Replies: 4
    • Forum: Excel Questions
  2. H

    Excel Formula: Skip blank columns in row (A2:D2) and transpose into a vertical list

    Hi all. I'm looking for a formula to skip blank columns starting in row 2 (horizontal list) and transpose only those cells with values into a single column list. Then, I'd like to move down to row 3 and continue to add only cells with values to the bottom of the new vertical list, and so on...

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