| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range division
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Division | Excel Worksheet Functions | |||
| Need help with division, please!!! | Excel Worksheet Functions | |||
| Division | New Users to Excel | |||
| Range of cells and division formula | Excel Discussion (Misc queries) | |||
| Division help? | Excel Discussion (Misc queries) | |||
Threaded Mode
