a40

  1. T

    Messagebox listing going down instead of across

    The code below lists the address of all cells in a pre-defined range whose value is zero. Dim Rng As Range With ws Set Rng = .Range(.Cells(1, 1), .Cells(1,1000)) End With Dim ZeroColl As Collection Set ZeroColl = New Collection Dim...
  2. C

    VBA Loop help for a few lines of code

    Hello, I just registered but I've been lurking here a while. I am trying to teach myself how to loop. This is the macro I have that I would like to loop. I believe I have enough info there so you know what I am trying to accomplish. Thanks a ton Sub Macro2() ' ' Macro2 Macro ' '...
  3. Z

    Find a cell that matches a pattern and return that cell's value with an incremented numerical value to the Active Cell

    I am trying to search for the first cell above my active cell (just in the same column) that contains the words BOX or SPARE. The words BOX and SPARE will also be followed by an integer value that's up to 3 digits long (e.g., SPARE 22 or BOX 81). I'm trying to find the first cell that contains...
  4. P

    Help with incrementing number and keeping text the same

    Hi there, I have this string in A1: Player 1 and I'd like to setup excel so no matter what I typed I A1, that all the other predetermined cells auto increment by 1. For example: If I typed "Player 1" in cell A1, then cells A2 through A40 would change to "Player 2", "Player 3", etc. Hope...
  5. Y

    Macro to copy from one sheet to another

    Hi All, Can someone please help me with a macro.... What I need to do is copy from sheet1 A33 - A40 to sheet 2, to the next available row col A-H Values in A33- A40 are numbers and change twice a week and I need to run the macro and copy those numbers in columns A-H, on the next available...

Watch MrExcel Video

This Week's Hot Topics

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
Top