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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top