VBA define multiple range within a worksheet

[EMcK01]

Hi,

I'm struggling to start this as I'm not sure how to make the script at different ranges within the worksheet.

I need to define a range to form a sum equation when it finds the first blank cell in the column, there is always a block of 3 blank rows together. I then need to repeat this for the next range of cells down the column.

As the ranges will always change I'm not sure how to make this dynamic so that it will find the first and last cell of the next range and step 3 rows once it finds a blank cell to then continue the loop again.

Any help would be appreciated.

Thanks

 

[johnnyL]

So, It sounds like you want to search a column for values to add up

1) Find the first value in the column to be added, add that first found value to a running total, continue down the column, adding the values in that column until a blank cell is encountered in that column, at that point, place the running total in that blank cell.

Continue down the column until you find the next value in that same column. start keeping another running total until a blank cell is encountered in that column, at that point, place the running total in that blank cell

Repeat process until the last used cell in that column is encountered and added.


That sound about right?

 

[Fluff]

I've already answered this in your previous thread.

VBA search cells in range with row skip

Hi, Is there a way to get the following code to skip 3 rows when it finds the rngEnd to ensure it then defines the range as appropriate? The ranges vary within the sheet but there is always 3 clear rows from the end of block of data before the start of the next block of data. Sub Test2()...

www.mrexcel.com

 

[EMcK01]

Hi Guys,

thanks for responding. I had started to put something together but Fluff sorted it right out for me.

Thanks for the response though, its appreciated.

EMcK