I am programming in VB. I want to divide a range of cells by one number, i.e.

the code i have is:

Range("C16:V16") = (Sheets(gstrCMCMCost).Range("B4:U4") / 1000)

This produces an error - A Type mismatch error.

This way works when I do one cell at a time. However I need to be able to do
all ranges at once. Is this possible?

Thanks