VBA help

[descrom93]

Hi guys, sorry if im not clear about my problem right away but Im new to excel. Im trying to find the average of 2-however many cells in the same row, but they arent always in the same place. I need a way to dynamically adjust the beginning and end of the average. Is there an easy way to tell excel this? I have lnCol as the col i want to start in, Yrs as the number as years are present, and 2 for adjustment, 

 

 

Cells(5, lnCol + Yrs + 2).Formula = "=Average(I5:J5)"

 

Thanks for your help

[Nuluvius]

You are being too specific without properly defining your context: Years, 2? How are we supposed to know what those magic variables even mean?

 

In any event a generic solution would be to scan (using a loop) for the first cell that is not empty. Then scan for the next empty cell... Under the assumption that the data is contiguous you then have your range.