new coder

  1. A

    VBA Split semicolon and comma separated values into new rows

    Hi there, These are some screenshots of what I'm trying to do: I am trying to split the Alias names into in new rows. There can be 1+ alias names which are separated by semicolon (;). The name format is LAST, FIRST MIDDLE; LAST, FIRST MIDDLE..... Then I need to duplicate the DOB and...
  2. S

    VBA Code- finding #Spill and moving the formula to the next column

    I'm not sure if it's even possible, but I need help in the following: so far, I made a made to insert rows, by the value of D minus 1, each time column D is >1. The macro is working from bottom to top since its trickier for the macro to function if the last row keeps changing as its going top...
  3. S

    VBA code help

    Hello, I'm super duper new to VBA coding with literally 0 past experience past this project I've been assigned at work. I basically need a code where the macro searches column D for cells >1 and then inserts rows according to the value in the cell while subtracting 1. So if a value is 2, 1 row...
  4. G

    How can i extract the correct leave time on this code?

    Hello everyone I've been recently given this VBA code Sub ENTRADAS_SAIDAS() Application.ScreenUpdating = False 'Beginning Range("A1").Select Rows("2:2").Select ActiveWindow.FreezePanes = True ActiveWindow.Zoom = 85 ActiveWindow.DisplayGridlines = False...
  5. H

    Simplify VBA code moving data around spreadsheet

    Hello! I just starting learning VBA to solve this problem. I have data that I need to interpret, but the way it is outputted makes it impossible. I figured out how to use VBA to solve it using this forum, but I am aware it is done about as clunkily as possible (i.e. I use a ton of 'Select'...
  6. K

    Application-defined or Object-defined error

    I'm new to VBAs and I pieced together this code for a random question generator. It worked the first few times but now every other time I click the button it comes up with an error. When it doesn't come up with the error it populates my form with the same questions not random ones anymore. Can...

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