Range in VBA to Cell Range (1 Viewer)

[mark curtis]

Hi folks,

I hope you can help:

In VBA macro i have worked out some ranges that i want and this works fine
Set rngNSS = Range("A" & intSRow & ":B" & intNSS - 1 & "")
Set rngEast = Range("A" & intNSS & ":B" & intEast - 1 & "")

I also have loads of cell calculations on the sheet that needs to use the ranges that i have worked out in VBA.

1) How can i replace the cell calulations in the sheet e.g =COUNTIF(RAW!$B$1:$B$295,C29) with the range worked out in VBA e.g =COUNTIF(rngNSS,C29)

Thanks
Mark