modify

Dear all I was hoping for some help with deleting certain columns My current macro is this: Rows(3 & ":" & Rows.Count).ClearContents Range("D2").Select This deletes everything from Row 3 onwards. However, I have fixed data I want to keep in A3:B9 Is there a way to modify it so that I can...

Appreciate highly, if any one help me in modify code this..

Hello, I want to apply a formula that searches a range modified by another formula. For instance, if you had a column with some unimportant two-character prefix and you wanted to perform a VLOOKUP on the 5 trailing characters, is there a way to do so without first creating a separate column...

I'm writing a macro that produces a table from external data, and I want the user to be able to format the report using a table style that they can modify. Is there a way that I can "call" the Modify Table Quick Style dialog from the macro and allow them to amend it? I know that I could create...

Please help me understand and modify this macro. My colleague wrote the macro listed below. It works just fine. Now I would like to add column P to do the same time. Can someone explain the If and null string part of the macro and help me modify it. I would like to learn this, so in the...

Hi, I'm trying to stream through a text file and remove a whole tag from the XML. "<" & "Tagname */><tagname *="">". (Ampersand just there as forum deletes the tag) <tagname *=""><tagname *="">The issue is the text/xml files can be anywhere from a few KBs to multiple GBs. The file also has no...

I am using randbetween(-10,10) to generate numbers, Occasionally I get a 0, is there a way to modify this so that I never get 0?

Hello, I've tried to modify an existing array formula that returns a list of all Projects meeting the "Yes" value on another sheet (Input) to exclude any lines that are duplicate. I can't get seem to get the modified formula right with regard to parenthesis, # of arguments, etc. Any help would...

I have an existing PivotTable. Now i want to modify it by adding 1 more Row field. Here's the VBA code: pvTbl.AddFields RowFields:="Company", AddToTable:=True The new row is added, but somehow all existing rows and filters are removed. From the documentation, if AddToTable is True, none of the...

This code works but it takes a few minutes to complete depending on the number of worksheets in the original workbook (see link below). The time is not of great concern; however, my laptop at times slow down considerably or freezes altogether during execution of the code. Is there a way to...

Hi everyone, Solution: I have a need for creating a simple message box that prompts a user with each mapped network drive in a file for an external link that shows them what the current drive is and a cell in the message box that lets them choose where the new drive needs to be mapped to. In...

Hi guys this is very urgent!,when i'm using below code macro's for creating looping till line no.7 everything is OK but the main problem is line no.8 . my actual problem is after completion of first loop it is showing maximum value in column 5 and row 1 but after second loop is over another...

Hello, The code below works fine. The problem is that it is very slow and clunk. I am not knowledgeable enough to find a better wat to make it work more efficiently. WHAT IT DOES: In an alphabetically sorted column, it rinds each row with the word "Benchmark" and deletes that row. It does...

I got following code, I need to put a location for sourcefiles in the code, but i want instead to have a dialogwindow See code below: 'The following code will combine all data into one excel workbook. Sub CombineFiles_Step1() 'Declare Variables Dim WorkbookDestination As Workbook Dim...

Good Day all, Recently one of our users created a number of Macros in which she placed on two customized tabs for Excel 2010. Later, as the administrator I was asked to add the customized tabs to 72 other users. I have very limited experience with either VBA or XML so I simply copied her...

I have recently changed from excel 2003 to excel 2010. And found to my disappointment that I can no longer graphically modify points in the series. In the 2003 version, I could click on the series in the trend and then click at a single point and then drag and drop the point to the desired...

I need to copy the same range from many sheets in the same workbook. I found Ron´s VBA solution, which basicly fits to me partly because this code below copy only specific range just from one sheet in specific workbook. But, I need to copy specific range from many sheets and i tried to modified...

On a userform I would like to select a work order number (no problem) and have a listbox or combo box come up with all the detail rows for that workorder which are contained in the same table. The rows of data could be up to 30 individual rows. I would be pulling about 6 columns of data. I...

Basically, I have a workbook with several sheets. Sheet 1 is a "master" sheet named UPDATE DRAWING INFO and it contains a ton of numeric and text values. The other sheets reference cells from this "master" sheet. This way, a change on the master sheet is reflected in all the other sheets. When...

Hello. I am trying to do a web query for specific data on a web page that is within a table that changes each time the webpage is modified. The order of the table I need is not the same for each web query I do. For example, the data I need will be in WebTables = "4" for one page but be on...