macro - loop

Hi All, Imagine I have 3 Workbooks open with File names ABC12345, DEF54321, GHI00000. These partial names are present in a column of an excel workbook say XYZ (ABC in A1 cell, DEF in A2 cell, GHI in A3 Cell) I want a macro which can select(or activate) the respective workbook by reading the...

Hello! i'm hoping someone can help me as i know the solution to my problem can be solved via a macro of some sort. I have a spreadsheet that containing 3 tabs, sheet1 sheet2 and sheet3. Sheet1 only has data in column A which is the unique values of my data range... there are over 100...

I've been running the macro below manually. I would like a macro to test column A which contains an If statement IF(B1=E1,1,0) on each row until row A is empty. I tried a suggestion from here before and if the value was 0, it called up this macro but the macro saw the value of 1 as a 0. If you...

I have a macro named AddLine that inserts a row. The macro below is supposed to check each row in column A, if A=0, it should run AddLine, if not, it should go down a row then test it again. This is my macro. It treats all values in column A as 0. Column A has and If to determine whether to put...

I have a macro button named "AddLine" that shifts cells down from E thru (End Right) as long as I start in column E. I want to test each line and if A = 0, run the macro "AddLine", if not then move down a line and repeat. I tried the following but it only inserts from the first row (which...

If cell A in row 1 equals 0 I need to run a macro from column E "AddLine" (which shifts cells from e thru end-right, down) If its not equal to 0 I need to continue to run it. This is what I have but it only inserts a whole row in row a1 then stops Sub MyInsertMacro() Dim myLastRow As...

I am very new to macros and would like some help please. (I want this to run on Excel 2000 on an XP machine) I have a macro that imports some data from a set file to my sells starting at A6. My question is how do I tell my macro to check if there is data in cell A6 and if there is delete all...

Hi all, I have this coding in my macro <!-- BEGIN TEMPLATE: bbcode_code --> <code>If blCreateFolder Then MkDir sSaveAsPath End If</code></pre> <!-- END TEMPLATE: bbcode_code --> When I select true on my master list the code encounters an error the second time it runs as there is...