swapping

  1. N

    Change Even involving Table or List Object

    I have a small bit of code I’d like to use listobjectlanguage with. [CODE] Private Sub Worksheet_Change(ByVal Target As Excel.Range)<o:p></o:p> If Intersect(Target, [Z:Z]) Is Nothing Or Target.Count >1 Then Exit Sub<o:p></o:p> Target.Offset(, 1)= Date<o:p></o:p>...
  2. E

    Swapping Ranges Question

    I am currently in the process of creating a macro that will swap two ranges on one sheet and then swap the same ranges on a different sheet automatically. The macro works and I am able to swap the first 2 ranges on the first sheet with this macro but then I have to manually enter the second...
  3. C

    Swapping adjecent cell values

    This is a bit of a weird one in that I don't know how I did what I did by accident, but it would be useful to know... My spreadsheet contains a (fairly standard) set of data of Surname (col A) Forename (col B) and more info in col c, d, e etc. I was using the keyboard to select the first 5...
  4. J

    Switching position of last name & first name strings without affecting position of an existing middle name string

    My data shows employee names in the following convention; lastname middlename firstname e.g. Persie Van Robin. I need to format the order of the name so that it appears as firstname middlename lastname e.g. so it appears as Robin Van Persie. A middlename will in many cases not exist. My macro...
  5. F

    Swap pasting - cutting and pasting cells' contents

    I'm doing a ton of corrections for mixed up information. Is there a function that will cut and paste a cell's contents and automatically push the destination's cells contents to the original cell that you cut from? i.e. - Swapping contents... if that does exists, I'd assume I could assign a...

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