non-contiguous

  1. S

    Deleting non-contiguous columns based on column number

    Hey everyone, I'm having a little trouble. I was able to select one group that I wanted to delete based on the column number because I am using a variable: Range(Columns(10), Columns(testint - 10)).Select Selection.Delete Shift:=xlToLefttestint is just the number of columns in the sheet But I...
  2. R

    Select non-contiguous range to the left

    How can I Select everyting to the left until I run into the wall (aka column A) without knowing how many times I need to hit the left arrow to get past the spaces? ie: Copy all data, non-contiguous, to the left of selected vertical range of cells example: If I select AB8:AB88, I want to push...
  3. S

    Counting and summing problem

    Hello, This is where I come when I can't get my head wrapped around an Excel problem. Y'all are the greatest. Thanks! Ok, I've got this report I'm working on. The format is set so there isn't any feasible way to split the information that's in a single column into multiple columns. Now I...
  4. A

    VBA Code for Print Area of non contiguous ranges

    Hi everyone, I would like to request some help with the following problem. I would like to use some code to set a non contiguous print area using columns A to E and K to AE. The number of rows is determined by finding the last row used. Here is the code I am up to at the moment: Sub...

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