View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sunny Sunny is offline
external usenet poster
 
Posts: 42
Default macro to increment/decrement values in selected cells

Hi
I am trying to write a macro to increment/decrement the values in a range of
selected cells (e.g. R3C3:R8C10).

I got as far as returning the address of the selected cells ("R3C3:R8C10")
using:
ActiveWindow.RangeSelection.address(True,True,xlR1 C1)

Now how do I use these address "corners" to cycle through the cells?
Range() and Cell() seem to require a different format.

Or, is there a simpler way to add/subtract/multiply a selected range of
cells by another value?

Thanks