Dynamic Range, based on user selection, used with FOR LOOP

Hey everyone,

I have a UI in which the user can click 1 of 13 buttons. Each button represents a different week. Each week is stored in a seperate column, starting with E. When they click the button the week is already stored as iWeekValue (int 01 - 13). The data that needs to be check also doesn't start until Row 4.

My question: I need help setting the range to be checked, how would I do that? Basically it needs to be E-Q4:E-Q LastRow. So if the user picks week 5 it would be I4:I LastRow.

Hopefully that makes sense... thanks to all who reply!

Hey protonLeah,

so I set iWeekColumn = iWeekValue + 4. So I am trying to get LastRow and iWeekColumn to return a range I can run a for loop through to check for any negative values.

But I am struggling to get the range... rngWorking = Range(iWeekColumn & BOMLastRow) --- what would be the right way to do this?

Maybe something like

Please Login or Register  to view this content.

This isn't quite right though... Is it the weekend yet?

Nevermind, I got it! Was so close....

Please Login or Register  to view this content.

Thanks for your help proton.