Range does not support R1C1 references.

I would suggest

Worksheets(strMstSht).Cells(intColNo,3).Value

but why would your row number be in a variable named intColNo?

--
Regards,
Tom Ogilvy

"SHIPP" wrote in message
...
I use a formula to obtain the row of the value I am seeking to obtain
which
is in a different worksheet than the one I am working in. I am trying to
use
the following

strOffset = "R" & Trim(Str(intColNo)) & "C3"
intDayDiff = Worksheets(strMstSht).Range(strOffset).Value

strOffset does contain the correct column # and returns R7C3. However I
get
an error in the intDayDiff line. Any help would be appreciated.
--
M. Shipp