tall

  1. G

    Stuck with Array Syntax - Convert Wide to Tall Format

    Hi Folks, I am trying to take a wide format array and using vba convert it to a tall skinny format. Currently my xl2bb is blocked so I pasted an example table at the bottom of this. Example wide format on left, desired format on right) My starting code is here. I've tried a few different...
  2. A

    Search column cells for multiple criteria

    I am trying to search for multiple text fields in column A and once they are all found in one cell, return the value of the next cell in column B. Example: I want to search for 10#, TALL, BOWL, and BLUE in column A and once all of them are found in one cell, return the Product No that is in...
  3. I

    VBA for page setup with dynamic number of pages tall

    Hi folks, I found on this forum a fantastic piece of code to set the page setup of a particular sheet in my workbook. Sub Print_Format() Dim LR As Long LR = Range("A" & Rows.Count).End(xlUp).Row With ActiveSheet.PageSetup .PrintTitleRows = "1:1" .PrintArea = "A1:I" & LR .LeftMargin...

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