Loop formula until column to left has empty cell

[wannabeexcelguy]

Hi gurus,

I've written the below code to sum all payments on row 2 in the next blank column of worksheet w2 (see below).

How can I have the below formula loop down the column until there is a blank cell in the column to the left i.e. Offset(0,-1)? I am trying to avoid using select and activecell etc.

Thanks in advance! Any help is much appreciated

Please Login or Register  to view this content.

[TMS]

You don't need a loop. Post a sample workbook.

Regards, TMS

[wannabeexcelguy]

Hi TMS, I think I do need a loop because this is part of a larger macro (the number of rows and columns with payments will vary each time it is run).

Example attached. Columns A:AL are blank because I removed sensitive information.

In this example, payments need to be summed from columns AN to KO in rows 2 to 1129.

Thanks!

[stnkynts]

Try this:

Please Login or Register  to view this content.

[wannabeexcelguy]

I thought you guys would be able to do this easy!

[stnkynts]

I thought you guys would be able to do this easy!

See my post above

[wannabeexcelguy]

Thanks stnkynts but when I run this nothing happens :?

[wannabeexcelguy]

Ended up doing it the lame way unfortunately.

Please Login or Register  to view this content.

[TMS]

I'm willing to be proved wrong, but if you post a sample workbook, I'll try to demonstrate ... or hold my hands up

[stnkynts]

I read your post wrong. Sorry about that.

[stnkynts]

Here. No Loop.

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[wannabeexcelguy]

Awesome, these both work! Cheers gurus. Knew you guys could do better than me haha.

[TMS]

You're welcome. Thanks for the rep.