vba loop

Purpose: Look at table in Parameters worksheet for find/replace parameters. Use these values to find/replace text in Sales worksheet. Heres the parameters table in the Parameters worksheet <tbody> IF then Entry Code WILL CALL (Winebridge) Wine Bridge STEWCH09 >>> CH09S1@VLX...

So I'm banging my head against the wall trying to run a macro that generates a new worksheet for every .dbf file in specified directory and then copies ranges of data. The code works great for the first file but then gets hung up on that first .dbf and never advances to the subsequent files. I'm...

Hi, I want to write macro which goes through each of the chart and delete everything on it. each text box, each hyper link, each header, each tag on x axis and y axis. I should just remain with blank chart window and nothing on it.... can any one please help.....thanks in advance (probably...

Hi, I have created a data entry macro that prompts the user for information and then enters it in the correct cell of the excel sheet. The user will be entering multiple lines of information so I need the macro called "newentry()" to repeat itself indefinitely, at least until the user clicks...

Hi VBAers, As I delve deeper into excel I am learning many more exciting functions but am also coming up against many more problems! Is there a way to use a "for...next" loop in order to copy the below code 300 times? i.e. I have 300 different text boxes that are conditionally formatted...

Hi, i'm looking for a solution to the following. I have a table like this: <table border="0" cellpadding="0" cellspacing="0" width="128"><colgroup><col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td...

Hey Guys.. Greetings.. Hope you doing good. I just entrap in a loop problem. :confused::confused: Here is the file attached with raw data dump and result desired sheets http://www.filefactory.com/file/cbc35f7/n/Excel_Loop_problem.xls Help requirement Details are in the sheets I am trying...

Ok here is my problem I have vba code that first displays first row of expected results then on the next row the code does a vlookup using the key in the expected to find the actual results. Problem is the vlookup is being used for every column which takes to long. Ideally I want it to vlookup...

Hello I'm editing a code I wrote to make it have the ability to handle a range of cells and not be limited to just one. The issue is that since I will not be the primary user of the workbook I need to dummy proof it a little. What I need to do is limit the code to only run in the top cells on...