excel vba 2010

I am writing code to change the read the formatting of the cells in my worksheets. I got the code working using for loops but it takes too long running this way. So I am trying to rewrite the code using arrays . On the worksheet I am on now I have two tables that I have to loop through. Table 1...

Hello, I'm trying to find a command that would temporarily pause my script and allow data from a database to be fully imported before continuing the script. It takes a few seconds for it all to be imported. My code doesn't account for this and it continues to run other subs that are based off...

HI Friends I have one question how to get data which is after "\" from right. Ex :- T:\Desktop\Files\Robart working.xls I want only last string which come after "\" that mean "Robart working.xls" this file path will not be same in future there will be more "\".however i need only last...

I am working with excel 2010. I am trying to write a script to go through the named ranges of the workbook and delete ones with #REF errors and add ones that don't exist. Currently I am using the Names range but I only get the last part of the range not the whole range so my code does not work...

Hi all, I'm new to using VBA in Excel, and I'm having a tough time getting my event handlers to work properly. I have data validation set up in a specific column. The user must choose from a specific list of part #s, which is listed above the cells with the data validation (current worksheet...

Banking & Finance Jobs, iim mba jobs, ecommerce, retail, business, development, manager, technology, healthcare, telecom, insurance, fmcg, media, bfsi, director, vp/avp, ceo/cfo, agm/dgm - iimjobs.com Hi all, Please find below data format for website scraping.please send me code on my email id...

Hi Masters, I have posted a separate thread on how to get data from webpage that requires a log in. I have sorted it out to start doing it but unfortunately, I have a debug error in running my macro in excel. It will not select the value that I indicated in my macro to select the chosen...

Hey guys does anyone have any clues on how to do this, I am having a hard time. Here is what I am going for. ----------------------------------------------------------------------------------------------------------- I would like a script that will check a range of data automatically every 10...

I am in need of your expert assistance. I am trying to write some code that will copy rows and insert the copied row below the last row in another sheet. I have a Global sheet that has the data i will be copying. It will need to look in column Q. I think the problem will be when trying to copy...

i am looking for a code to search for a single cell value in multiple cell value and return the adjacent cell for eg- in sheet 1- A B 4F876 Sheet 2- A B 4F876 4M4646 5GAR 100 Column B in sheet 1 should return 100 value. Please help.

Hi I am currently using the code below to read the data from worksheet 'data' to a cell in the current active worksheet. This works fine. I now need to change this so that worksheet 'data' is a new, separate spreadsheet. I need to be able to define the folder and the filename of the new...

Hello, I am brand new to VBA and I have some code to transfer data from multiple spreadsheets into one master spread sheet. This works ok but at the end I need to clear the days data from each of the spreadsheets so the data can be transferred again the next day with out duplicating. Is there...

So I am very new to VBA, and I'm trying to piece together what I can on my own. I have this code, used to remove data on a certain line, in reference to data being collected on a summary page. I have employee's on row A7:B30 as Last Name/First Name. and their Data on each monthly tab there...

If Range("C" & (i - 1)).Value + Range("C" & i).Value = 0 Then ActiveCell.Formula = (Range("D" & (i - 1)) + Range("D" & i)) / (Range("C" & (i - 1)) + Range("C" & i)) Else ActiveCell.Formula = "0.00%" End If This is not working !! can anyone suggest where's the mistake? I am getting Overflow...

Hello, I am requesting assistance from RoyUK; a lot of your post has helped me and I'm urgently needing your assistance...of course this is open to anyone else who can assist. I'm not an "expert" with VBA but know enough to be dangerous, which is dangerous :eeek: At any rate, I have a...

Q: I need to simply paste the values of the row at my discretion (button) so that they remain permanently where I pasted them.If they already exist there then update them otherwise paste to the last non empty row. From where they get copied the rows can change , new rows can come and go...

Hello, this is my first post, hopefully someone will be able to help. I'm having some issues in automating a PowerPivot slicer using vba. What I am trying to do is have the slicer update and only select what is in a certain cell. So for example assuming the cell was A3 then whatever was typed in...

I have a large excel spreadsheet where I need to merge rows on a unique identifier. I'm trying to develop an Excel VBA macro but still lack the proficiency to tackle this. Here is a picture of an example of what I'm trying to do. The data including the headers are all made up for the example...

Am new to VBA & trying to learn as I go. Am currently stuck with an Issue here which I need some help. Am trying to open an Excel workbook(<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu...

I'm trying to learn Excel VBA with the Safari Microsoft Excel VBA Programming for the Absolute Beginner, 3rd ed. for Excel 2007. But I have Excel 2010. From Excel, when I attempt to insert an object from the Insert>ActiveX Controls, as per the book's instructions, I get an error box that says...