Fixed Cell Reference

[Jonathan78]

Hello all,

I'm looping through a range.
The range covers multiple rows and columns.


I need the cell refrence however to always check the value in range D7:AA7
In a formula whe would write it like D$7:AA$7 but I'm not sure how to do this in VBA

I've tried the following, but that did not work.

Please Login or Register  to view this content.

any ideas?

[StephenR]

Why not

Please Login or Register  to view this content.

?

[Jonathan78]

Just found it out myself

Please Login or Register  to view this content.