Count Formula with Relative Reference

**amotto11** · 08-10-2012, 10:12 AM

Hi All,

It has been a rough morning and i cannot figure out why this is not working. Thanks for any help

Please Login or Register  to view this content.

I am trying to put a formula in J2 that says count from M2 to (A Variable Column)2

Thanks

**TMS** · 08-10-2012, 10:23 AM

Maybe:

Range("J2").Formula = "=Count(M2:" & Cells(2, ColumnCount).Address & ")"

Regards, TMS

**amotto11** · 08-10-2012, 10:28 AM

Sorry, .Address makes the reference stay there, $C$4, i would like it to be $C4 or C4.

Thanks

**amotto11** · 08-10-2012, 10:47 AM

I figured it out, all i needed was (0,0) after .address

**TMS** · 08-10-2012, 11:39 AM

You're welcome. Thanks for the rep.

Re: Count Formula with Relative Reference