View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default range calculations

If I am try to put an equation in a cell how do I reference the cell


Range("E1:E100").Value = "=D<row / 100000"

Obviously this doesn't work but what would be the correct syntax to do
something like this. I don't want to do a loop.


Thanks
Mike