non adjacent

  1. M

    Direct Referencing Non Contiguous Columns

    Hi all, long time lurker first time poster. I am somewhat of a VBA newbie and am trying to write a script to assign values from one of my workbooks to a template workbook, however the data in the source file is non contiguous. The below script does not cause an error. however the data from the...
  2. Y

    Cutting or moving multiple non adjacent rows to the bottom of a data set using vba

    Good day, I am carrying out an analysis of data submitted. the nature of the analysis is to seek variances in the data. one of the variances is multiple submissions on the same data. what I am aiming to do, is to cut all the first occurring duplicates to the bottom of the data. I have already...
  3. R

    Non adjacent cells selection

    Hi Simple question which I've struggled with.. I want to select non adjacent cells e.g. A1 and C1. I tried Range(Cells(1, 1), Cells(1, 3)).Select amongst other things but to no avail. Thanks
  4. B

    Copying non adjacent cells in a continous (adjacent) way

    Hello everyone, I' m new with VBA and I have a problem. Simply put, I have multiple sheets open each named after the date ("1.1." , "2.1." etc. let's say it goes for the whole year). I have an engineering simulation for a solar system. Basically I have in one column let's say column A multiple...
  5. D

    Display both Content of non adjacent cell if one cell value is greater than, other wise don't display

    Hi, :confused: please is a guru there that help me on which formula to use on following task?: B3:B38 Have numbers between 01 to 100, Then on AC3:AC8 there are Score that belong to each of these numbers. What i need to achieve is : (using B3 as example) If number of B3 have an Score...

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