excel vba help

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

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

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

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

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

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

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

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