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

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