excel vba help

  1. P

    vba excel

    · Function MovieWithLargestRental(rngMovie As Range, rngMovieRental As Range) As String This function finds and returns the movie with the largest number of rentals. There are two input parameters, the first is a range from the worksheet that has the name of the movies, while the second is a...
  2. R

    Summarizing Data From A Year Period - Multiple Columns With Same Name and Different Dates

    Hey Guys, First I must say that you guys were INCREDIBLY helpful last time I reached out on the forums and I have since purchased the Mr. Excel book collection and have begun to work through it but I am in a bind at work and was hoping for some help. So I have a file of 2,166 columns that list...
  3. N

    Help Required..Excel macro from Excel to Word

    I want to do this using excel vba macro. I have to find specific text (say "abc") in a word doc and replace that with a range of cells say range("A5:A7") in the current active excel sheet. I am badly stuck on this.Please help..!!! Thanks Naveen
  4. M

    Jump to spot in a range of cells that is alphabetically correct

    This is for Excel 2010 VBA I have a named range called "Find_Item", when I type something in I want it to search for that name in a range that also contains spaces. If that name isn't there then I want it to jump to the appropriate alphabetical spot. This is the macro I have now, below. It...
  5. A

    SplitToSheets()

    Hello, I am trying to use the vba code below to copy and paste simmilar data from a very large excel sheet where column A has unique identifiers and this is how I would like to seprate my different excel sheets that will be created with the vba code. But i get stuck on "Set stName =...
  6. M

    Excel VBA Userforms how to enable a ruler

    I am a bit of a novice with Excel VBA. I am wondering if there is a setting or some way to include a ruler at the top of a user form sort of how Access has the rulers on the top and sides. I am trying to create multiple user forms that need to have dimensions of 8 and half inches by 11 or a...
  7. L

    optimize VBA CODE help pls

    Hi Can someone kindly help me optimize this code pls.....is there a way to run this code in the fastest possible way??? Tonnes of thanks in advance:) Range("lj51:lj887") = "=IF(RC[-164]="""","""",RC[-164])" Range("lj51:lj887").Select Selection.Copy Selection.PasteSpecial...
  8. K

    Need help with macro please!

    I’m not very experienced with Excel VBA and I’ve got a problem I’m having trouble finding a solution to – I’d sincerely appreciate some help! <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a spreadsheet that is the result of importing company...

Some videos you may like

This Week's Hot Topics

Top