variable range

The following five lines of code are inside a loop in which i goes from 1 to 600. When i was 594 a condition allowed these lines to be executed. (The last was in my original code and the others were just added to try to figure out why the last had a problem.) The first three work and the last...

Hi, I am hoping some excel experts could help me with a problem. My data in general; columns 1-17 are general variables, Columns 18-29 are VBA driven IF Then statements based on values in 1-17. Each row can, and most likely will, have more than one 'true' If statement in columns 18-29...

Hi everyone, I have completely no prior experience in VBA and am a beginner at excel, but I have just discovered the wonders of macros. I am trying to copy and paste values from variable rows (from Row 5 to Unknown) and fixed columns (A to AF) of a specified sheet (named "Movement") from...

Hello, I've been searching for a way to do this for a little while. What I am trying to do is during a loop operation, which subtotals variable ranges, I want to store the locations of the cells that it puts the sum function into. I.E. if based on criteria it determines that range E4:E12 is...

Hi all I'm a newcomer to this forum so please forgive any non-compliance to any conventions etc. My questions refers to the following (sample) data Column A Column B Column C Workbook Name Criteria Countif(how it should look for correct results) 'abc.xls'!$C:$C...

Hi there, I've got a short question: I have two variable ranges: One in row 4, starting in column F One in Column E, starting in row 5 I want to set a range for a macro for these two variable ranges. So one is Range("F4:.....") and the other one is Range("E5,....). I have to find the Last...

I am building a spreadsheet for a client to use. The client will add rows as needed but would like to see totals as the bottom row. Is it possible to write a formula that would determine if it was the last row and then insert totals. If not the last row, perform lookups or other math as it does...

Hello, I am using MSExcel 2003 and have recorded a macro that I would like to edit but am coming up short on a good solution. The sub routine will insert columns and convert data from other columns using the UPPER function. I have copied out a portion of the macro below and feel that if I...

Hello again. My current problem is something I thought would be easy because I thought VBA would have an Auto Sum function, however I have not been able to find one. I'm using Excel 2007. I have a template that has a summary page. The summary page has seven sections, each section length (in...

Hi All, Thanks again for your excecllent help in the past. I have a data export function that finds a dynamic range, copies the values and inserts into a new worksheet. This part is working well. What I need it to do next is to insert two columns before the imported data and add a simple...

Hi all, I need to select a range (on a different worksheet than the active one) based on input so I created this code: Where RLocatie is the row number. But I get runtime error 1004 on the second line of code. For some reason Excel can't select the range? Does anyone know what might be...

Here's my problem. I have a range that will move down to include all the records with the same value in column 2, however, when I try to lookup a value in this range after the first range has changed, I get an error. I don't know if it helps, but for j=1 c1=2 and c2=143, for j=2, c1=144 and...

I am trying to interpolate between two values that I need to look up. The problem is that the range of values that I need to interpolate for will change. How do I set a range that will adjust to the parameters I need it to? Also, I have left out the interpolation part so any help on this would...

Hello, I am stumped on an issue. I'm trying to build in a formula into a macro I have. There are a few worksheets that have 2 sections of data. The formula resides in between these sections. For example, section 1 of data will begin in row 2 and go to row 1000, section 2 will begin in row...

Hello All, I am having a bit of a problem with the syntax of a Goal Seek Command in a macro and would certainly appreciate any assistance. I have 30 cells which may trigger a goal seek if a certain value is above 0. The cells I am checking for the value > 0 are in D138 thru AE138. The goal...

Hi, I have a series of data that is updated each month. The cells are formulas that feed from other worksheets. so in February, the data looks like this: <TABLE style="WIDTH: 64pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=85 x:str><COLGROUP><COL style="WIDTH...

I'm looking for a way to use the sumifs function with the criteria refrencing to a different cell, but also being a range. Basicaly I want to change the formula : =sumifs(a2:a10,b2:b10,"<10"), but instead of using <10 as a criteria, it must be refer to a cell (like <$C$2). I've tried...