set range with offset

[rki1966]

In my macro I have counter that sets the location of offset by 1 row but want to use the value of colcnt2 as the column number. I do not want to add one to each time.


Here is the row offset which I want to increase by one. This part works.
Set Allocation = Allocation.Offset(rowoffset:=1)

Please let me now if you need more details.

 

[rki1966]

MrKowz,

Were you able to figure it out?

 

[MrKowz]

Sorry, I haven't had much of a chance to look at this more. A pile of work got dropped off that I need to hammer through before I can check this out. I've taken note of this post and I'll hopefully be able to provide a solution at some point today.

 

[rki1966]

Thanks for your help.

 

[MrKowz]

Rki,

I apologize for the wait, I have found some time today to revisit this and try to solve it. Would you please describe to me where exactly the values for Allocation, Prices, and Target are being pulled from? I tried working with the named ranges, but without having an idea of what your input data looks like, it is rough for me to find a working solution that will fit your needs.